如何在SharePoint 2013中更新Excel工作表 [英] How to update the excel sheet in SharePoint 2013
问题描述
用户从SharePoint内部库中下载了excel国家/地区数据，文件夹名称为"Acruals Reports".
User downloaded excel countries data from SharePoint Internal Library, folder name called "Acruals Reports".
我使用在SharePoint中打开/创建的启用宏的Excel工作簿模板，用于某些形式和计算.而且Macro每天晚上都会运行，并更新电源BI.
I use a macro-enabled Excel workbook template that is opened/created in SharePoint, for certain forms and calculations. And Macro excel being running every nightly and updates the power BI.
问题是:
当用户将数据添加到SharePoint库时，是否可以从SharePoint字段中获取数据并将其插入到我的Excel工作表中，并自动插入到特定的单元格中?
When users add data to the SharePoint library, Is it possible to take data from a SharePoint field and plug it into my Excel sheet, into a specific cell automatically?
注意:
我的一位同事说使用Excel Services REST API，但对此我一无所知.
One of my coworkers said use Excel Services REST API, but I have no Idea about that .
推荐答案
您是如何从SharePoint库中的应计报告"文件夹中下载excel国家/地区数据的?您是否在图书馆中使用了出口至卓越"?您能否提供有关该问题的更多详细信息?
How did you download the excel countries data from folder "Acruals Reports" in the SharePoint library? Did you use "export to excel" in the library? Could you please provide more details about the issue?
您是否将启用宏的Excel工作簿存储在SharePoint中的一个文档库中?
And did you store the macro-enabled Excel workbook in one document library in SharePoint?
如果是这样，您可以按照同事所说的那样使用excel服务REST API.
If so, you could use the excel service REST API as your coworkers said.
将数据保存在文档库中时，我们可以获取数据并调用excel服务REST API将数据写入excel工作表.
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.
更多参考:
Excel Services REST API的示例URI.
Sample URI For Excel Services REST API.
使用OData从SharePoint Server请求Excel工作簿数据.
Requesting Excel workbook data from SharePoint Server using OData.
还有另一种方法.我们可以使用事件接收器.当数据添加到文档库中时，我们可以触发事件接收器，并通过C#将数据写入excel工作表.
And there is another method. We can use event receiver. We can trigger the event receiver when the data is added into the document library and write the data into the excel sheet by C#.
最诚挚的问候，
萨拉范
这篇关于如何在SharePoint 2013中更新Excel工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
