C#Aspose.Cells导出xlsx格式Excel，打开文件报“Excel已完成文件级验证和修复。此工作簿的某些部分可能已被修复或丢弃”...

public void download()
{string fileName &＃61; "456.zip";//客户端保存的文件名string filePath &＃61; AppDomain.CurrentDomain.BaseDirectory.Replace("\\", "/") &＃43; "Excel/123.zip";System.IO.FileInfo fileInfo &＃61; new System.IO.FileInfo(filePath);if (fileInfo.Exists &＃61;&＃61; true){//每次读取文件&＃xff0c;只读取1M&＃xff0c;这样可以缓解服务器的压力const long ChunkSize &＃61; 1048576;byte[] buffer &＃61; new byte[ChunkSize];Response.Clear();//获取文件System.IO.FileStream iStream &＃61; System.IO.File.OpenRead(filePath);//获取下载的文件总大小long dataLengthToRead &＃61; iStream.Length;//二进制流数据&＃xff08;如常见的文件下载&＃xff09;Response.ContentType &＃61; "application/octet-stream";//通知浏览器下载文件而不是打开 Response.AddHeader("Content-Disposition", "attachment; filename&＃61;" &＃43; HttpUtility.UrlEncode(fileName));
//加上设置大小下载下来的.xlsx文件打开时才不会报“Excel 已完成文件级验证和修复。此工作簿的某些部分可能已被修复或丢弃”Response.AddHeader("Content-Length", iStream.Length.ToString());using (iStream)//解决文件占用问题&＃xff0c;using 外 iStream.Dispose() 无法释放文件
{while (dataLengthToRead > 0 && Response.IsClientConnected){int lengthRead &＃61; iStream.Read(buffer, 0, Convert.ToInt32(ChunkSize));//读取的大小Response.OutputStream.Write(buffer, 0, lengthRead);Response.Flush();dataLengthToRead &＃61; dataLengthToRead - lengthRead;}iStream.Dispose();iStream.Close();}Response.Close();Response.End();}
}

Response.AddHeader("Content-Length", iStream.Length.ToString());