当我们在文档库中保存数据时更新Excel工作表 [英] Updating Excel sheet when we save data in document library

问题描述

User did download the excel countries data from different folders in the one SharePoint library Using "export to excel". And also he store the Macro-enabled excel workbook .

1-当我们将数据保存在文档库中时，我们可以获取数据并调用excel服务REST API将数据写入excel工作表.如何做到这一点?

1- When we save data in document library, we can get the data and call excel service REST API to write the data to the excel sheet. How to achive this ?

2-在SharePoint中存储的Excel工作簿中运行宏时是否可能?

2- Is that possible, when running Macro's in Excel Workbooks stored in SharePoint?

推荐答案

1.我们可以使用Excel Service Rest API获取数据:

1. We can get data with Excel Service Rest API:

http://serverName/sites/sitename/_vti_bin/excelrest.aspx/Shared%20Documents/ExcelChart.xlsx/model/Ranges('A1|B8')

插入值:

http://contoso/Finance/_vti_bin/ExcelRest.aspx/Shared Documents/Tax.xlsx/Model/Charts(‘RevenueChart’)?Ranges(‘TaxRate’)=0.50

参考:

SharePoint 2010 Excel REST服务

SharePoint 2010 REST API语法中的Excel Services

2.如果将Excel文件存储在SharePoint中，则要运行Micro，我们需要在Client Excel应用程序中打开此文件，因为Excel服务将不支持运行Macro.

2. If a excel file stored in SharePoint, to run Micro, we need to open this file in Client Excel application, because excel service won't support running Macro.

请在此处查看官方博客，以了解在浏览器和Excel应用程序中使用工作簿的区别:

Please check official blog here about the difference using a workbook in browser and Excel application:

Differences between using a workbook in the browser and in Excel

谢谢

最好的问候

这篇关于当我们在文档库中保存数据时更新Excel工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！