在SharePoint 2013中导出到Excel功能列表&库不在Chrome浏览器中运行 [英] Export to Excel functionality in SharePoint 2013 Lists & Libraries not working in Chrome Browser

问题描述

SharePoint 2013列表中的导出到Excel功能&图书馆无法在Chrome浏览器中运行。  相反，我们
得到的错误看起来像这样：

 
 WEB 
 1 
 https://abc.com/_vti_bin/owssvr.dll?XMLDATA=1&List={6A7506F9-FE42-48F2-997C-C8FEA1CB7492}& View = {2C858E93-7D63-41CF-994E-A4AB32C0D902}& RowLimit = 0& RootFolder =％2fLists％2fHUBUserRoleMapping 
 
 Selection = {6A7506F9-FE42-48F2-997C-C8FEA1CB7492}  -  {2C858E93- 7D63-41CF-994E-A4AB32C0D902} 
 EditWebPage = 
格式化=无
 PreFormattedTextToColumns = True 
 ConsecutiveDelimitersAsOne = True 
 SingleBlockTextImport = False 
 DisableDateRecognition = False 
 DisableRedirections = False 
 SharePointApplication = https://abc.com/_vti_bin 
 SharePointListView = {2C858E93-7D63-41CF-994E-A4AB32C0D902} 
 SharePointListName = {6A750 6F9-FE42-48F2-997C-C8FEA1CB7492} 
 
 
 RootFolder = / Lists / HUBUserRoleMapping 
 

据我了解，这是因为该功能使用ActiveX但由于chrome不支持Activex控件，因此
无效。

请为此建议解决方案。

---

Pradeep Varanasi

解决方案

Hi Pradeep，

作为一种解决方法，我们可以将以下代码添加到脚本编辑器Web部件到列表视图页面中，以将数据导出到Excel。它在Chrome中工作。

< script type =" text / javascript" src =" https://code.jquery.com/jquery-3.2.1.min.js"> ;< / script> 
< script type =" text / javascript"> 

（function（）{
var listGUID =

（" .ms-listviewtable"）。attr（" id"）。s​​plit（"} - "）[0] +"}" ;;
var viewGUID =

Export to Excel functionality in SharePoint 2013 Lists & Libraries not working in Chrome Browser. Instead, we get errors that look something like this:

WEB
1
https://abc.com/_vti_bin/owssvr.dll?XMLDATA=1&List={6A7506F9-FE42-48F2-997C-C8FEA1CB7492}&View={2C858E93-7D63-41CF-994E-A4AB32C0D902}&RowLimit=0&RootFolder=%2fLists%2fHUBUserRoleMapping

Selection={6A7506F9-FE42-48F2-997C-C8FEA1CB7492}-{2C858E93-7D63-41CF-994E-A4AB32C0D902}
EditWebPage=
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
SharePointApplication=https://abc.com/_vti_bin
SharePointListView={2C858E93-7D63-41CF-994E-A4AB32C0D902}
SharePointListName={6A7506F9-FE42-48F2-997C-C8FEA1CB7492}
RootFolder=/Lists/HUBUserRoleMapping

As I understand it, this is because the functionality uses ActiveX but as chrome will not support Activex controls it is not working.

Please suggest solution for this.

---

Pradeep Varanasi

解决方案

Hi Pradeep,

As a workaround, we can add the following code into a script editor web part into list view page to export the data to excel. It working in Chrome.

<script type="text/javascript" src="https://code.jquery.com/jquery-3.2.1.min.js"></script>
<script type="text/javascript">

(function(){ var listGUID=

(".ms-listviewtable").attr("id").split("}-")[0]+"}"; var viewGUID=

这篇关于在SharePoint 2013中导出到Excel功能列表&库不在Chrome浏览器中运行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！