C# 从内存流打开excel工作簿

open excel workbook from memorystream

提问by afkmaster

I am trying to open an excel workbook from a memorystream. I have a web url of the excel file, what I do is I download the data from the url, then save it into a memorystream, but I am not sure how to open the workbook from the stream, here is how my code works so far.

我正在尝试从内存流中打开一个 excel 工作簿。我有一个 excel 文件的 web url，我所做的是从 url 下载数据，然后将其保存到内存流中，但我不确定如何从流中打开工作簿，这是我的代码的工作原理远的。

WebClient wc = new WebClient();

byte[] fileArray = wc.DownloadData("url is inserted here");

MemoryStream ms = new MemoryStream(fileArray);

But from here I'm not sure how to go about reading the data from the stream to create the workbook, it doesn't seem like the spreadsheet document from http://msdn.microsoft.com/en-us/library/ff478410works the way I want it to, any assistance or pointers would be appreciated

但是从这里我不确定如何从流中读取数据以创建工作簿，它似乎不像来自http://msdn.microsoft.com/en-us/library/ff478410的电子表格文档以我想要的方式工作，任何帮助或指示将不胜感激

采纳答案by Antonio Bakula

SpreadSheetDocument has an Openstatic method overload that takes stream as param for document source, just add to your code :

SpreadSheetDocument 有一个Open静态方法重载，它将流作为文档源的参数，只需添加到您的代码中：

var doc = SpreadSheetDocument.Open(ms, isEditable);