自动在共享点上打开，更新和保存电子表格 [英] Automatically open, update and save spreadsheet on sharepoint
问题描述
我们正在尝试自动更新在共享点上发布的电子表格.
We are trying to automate the updating of a spreadsheet that is published on sharepoint.
我们正在尝试开发一个SS Integration Services作业，该作业(1)在SharePoint上打开电子表格，(2)刷新连接，然后(3)再次保存它.除其他外，我们在VBA脚本中的登录过程存在问题.
We are trying to develop aan SS Integration Services job that (1) opens de spreadsheet on SharePoint, (2) refreshes the connections and then (3) saves it again. Amongst others we are having issues with the login process in a VBA script.
有人可以为我们指出实现这一目标的正确方向吗? (尚未提供PowerBI).
Can somebody point us in the right direction to achieve this? (PowerBI is not yet an option).
推荐答案
嗨Aziona，
Hi Aziona,
在SharePoint 2010中，excel服务是打开更新并将更改保存到excel文件的一个不错的选择，请参考下面的演示以开始:
In SharePoint 2010, excel service is a good option to open update and save changes to excel file, please refer the demo below for a start:
在Sharepoint 2010中以编程方式打开\编辑\保存excel工作簿:
谢谢
最好的问候
这篇关于自动在共享点上打开，更新和保存电子表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
