c# 读取远程Url excel

Question

BinaryFormatter serializer = new BinaryFormatter();using (System.IO.MemoryStream memStream = new System.IO.MemoryStream()){memStream.Position = 0;WebClient webClient = new WebClient();var obj = webClient.DownloadData(fileName);//fileName 是远程url地址，可以url直接下载serializer.Serialize(memStream, obj);workbook = new HSSFWorkbook(memStream); //在这儿就报错了，报错异常在下面}异常：ICSharpCode.SharpZipLib.Zip.ZipException: 'EOF in header'

Answer 1

1、你看下memStream里面有没有东西。

2、如果有，应该就是指针问题了，你序列化到memStream后，需要将指针 memStream.position=0，类似这样。