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，类似这样。