当我使用EPPlus生成Excel文件时,Excel会给我以下错误消息:
Excel无法打开文件'myfilename.xlsx',因为文件格式或文件扩展名无效。请确认文件未损坏并且文件扩展名与文件格式相符。
这是我的代码:
public ActionResult Index()
{
using (ExcelPackage package = new ExcelPackage())
{
// I populate the worksheet here. I'm 90% sure this is fine
// because the stream file size changes based on what I pass to it.
var stream = new MemoryStream();
package.SaveAs(stream);
string fileName = "myfilename.xlsx";
string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
var cd = new System.Net.Mime.ContentDisposition
{
Inline = false,
FileName = fileName
};
Response.AppendHeader("Content-Disposition", cd.ToString());
return File(stream, contentType, fileName);
}
}
有什么想法我做错了吗?
myfilename.xslx
,而您的代码中显示的是myfilename.xlsx
。您真正使用的是哪一个? - M.Babcock