62,261
社区成员
发帖
与我相关
我的任务
分享sql生成好的excel怎么自动下载？
写了个静态方法，想在按下linkbutton后调用这个方法，可是点了linkbutton后发现不会自动下载，但是文件生成了，怎么回事，应该怎么改代码？
public static void toexcel(DataSet ds)
{
//、、、。。。省略
save_path = temp_path + "\\" + tick + ".xls";
url += tick + ".xls";
workbook.SaveAs(save_path, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
excelOperate.Dispose(worksheet, workbook, app);//关闭Excel进程
System.Web.HttpContext.Current.Response.WriteFile(save_path);
System.Web.HttpContext.Current.Response.End();
}
...全文
请发表友善的回复…
发表回复
huangwenquan123 2010-02-25
- 打赏
- 举报
Response.ContentType = "application/octet-stream"; 这句话是什么都可以下载吗？
例如图片，word等等。
lxiron 2010-02-25
- 打赏
- 举报
Response.......后面怎么写忘记了
zhangkewen1234 2010-02-25
- 打赏
- 举报
学习！！ 回复内容太短了
wuyq11 2010-02-25
- 打赏
- 举报
string path = Server.MapPath("~/") + "";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(Name, System.Text.Encoding.GetEncoding("utf-8")) + "." + AttachmentExt);
Response.ContentType = "application/octet-stream";
Response.WriteFile("" + path + "");
Response.End();
Response.AppendHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(Name, System.Text.Encoding.GetEncoding("utf-8")) + "." + AttachmentExt);
Response.ContentType = "application/octet-stream";
Response.WriteFile("" + path + "");
Response.End();
mengjun5200 2010-02-25
- 打赏
- 举报
linkbutton效果都一样的啊，而且我想做成链接的形式
polarissky 2010-02-25
- 打赏
- 举报
用button不行么？
