且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何使用 Excel VBA 将项目添加到 Sharepoint 列表?

更新时间:2023-12-06 11:36:52

所有数据操作都可以通过 SharePoint 列出名为 lists.asmx 的 Web 服务.您必须调用该 Web 服务.例如 UpdateListItems 方法 应该做 MS Access 现在做的事情.

All data manipulations can be done through SharePoint Lists Web service named lists.asmx. You have to call into that web sevice. For instance UpdateListItems method should do what MS Access does now.

您可以用来访问列表网络服务的一个选项是Microsoft SOAP Toolkit",它必须作为办公组件安装(从未安装过,但这里有一篇文章描述它:http://oreilly.com/pub/h/1306

One option you can use to access the lists web sevice, is "Microsoft SOAP Toolkit" which has to be installed as office component (never done that, but here is an article describing it: http://oreilly.com/pub/h/1306

另一种选择是使用 MSXML 库(始终可用)并将 SOAP 请求作为简单的 HTTP 请求发送.然后将结果解析为xml.有一篇文章展示了如何做到这一点:http://blogs.msdn.com/b/jpsanders/archive/2007/06/14/how-to-send-soap-call-using-msxml-替换-stk.aspx

Another option is to use MSXML library (which is always available) and sending SOAP requests as simple HTTP requests. Then parsing the results as xml. There is an article showing examples how to do it: http://blogs.msdn.com/b/jpsanders/archive/2007/06/14/how-to-send-soap-call-using-msxml-replace-stk.aspx