求服务器端不保存，直接提供客户端下载Excel的方法

[cherry_j]

服务器端已在内存中生成workbook
此时想提供客户端直接下载并打开excel

急啊

[cherry_j]

????

[wanghui0380]

服务器端已在内存中生成workbook,你应该是指已经生成一个stream流,那么好!直接输入这个流就是了,输出前改一下mime类型就可以了
Response.ClearContent();

Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");

Response.ContentType = "application/excel";

[None465465535]

HttpListener

[cherry_j]

还不是很明白

[wxdxy]

怎么在内存中生成excel啊

[lovewen62]

在轉EXCEL文件代碼的PAGE_LOAD里寫下如下代碼看行不行？



Response.Clear();
Response.Buffer = true;
Response.AppendHeader("Content-Disposition", "attachment;filename="+ DateTime.Now.ToString("yyyyMMdd") + ".xls");
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.ContentType = "application/vnd.ms-excel";
this.EnableViewState = false;