c# - c#中的Excel插件

Question

我写了一个 excel 插件，它创建一个工作簿并向其中添加连接对象。但是，一旦我将连接添加到工作簿，它就会开始从源下载数据。我们如何避免数据下载并仅向工作簿添加连接。以下是我的代码的快照:-

Application app = new Microsoft.Office.Interop.Excel.Application();
app.Visible = false;
WorkBook workbook = app.Workbooks.Add(1);
string connectionString = "DATAFEED;Data Source=" + odataURL + ";Namespaces to Include=*;Max   Received Message Size=4398046511104;Integrated Security=Basic;User ID=" + tokens[0] + ";Password=" + tokens[1] + ";Persist Security Info=false;Base Url=" + odataURL;
workbook.Connections.Add2("Feeds", "MyFeeds", connectionString,"ExecutedReport", Type.Missing,  true, Type.Missing); // this step downloads data from source. How to avoid it.

Answer 1

尝试设置 Workbook.UpdateRemoteReferences为 False。

有关此 Microsoft 的 Excel Development site 的详细信息.