导出excel模版

方法一:

 public void ToExcel(){

 //第一步:获取模版物理路径

 string file_1 = Server.MapPath("/Content/Excel/downExcel.xls");    

 //第二步: 写入客户端

 System.IO.FileInfo filet = new System.IO.FileInfo(file_1);

 Response.Clear();

 Response.Charset = "GB2312";

 Response.ContentEncoding = System.Text.Encoding.UTF8;

 // 添加头信息,为"文件下载/另存为"对话框指定默认文件名   

 if (file_0.IndexOf(".xlsx") > 0){

    Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode("订单详情.xlsx"));

 }

 else if (file_0.IndexOf(".xls") > 0){

   Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode("订单详情.xls"));

 }

  // 添加头信息,指定文件大小,让浏览器能够显示下载进度   

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

  // 指定返回的是一个不能被客户端读取的流,必须被下载

  Response.ContentType = "application/ms-excel";

  // 把文件流发送到客户端   

  Response.WriteFile(filet.FullName);

  // 停止页面的执行   

  Response.End();   

}

方法二:

public void  excelModel(){

  //第一步:获取模版物理路径

  string path= Server.MapPath("/Content/Excel/downExcel.xls"); 

  //第二步:写入客户端

  FileStream fs = new FileStream(path, FileMode.Open);

  byte[] bytes = new byte[(int)fs.Length];

  fs.Read(bytes, 0, bytes.Length);

  fs.Close();

  Response.Charset = "UTF-8";

  Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");

  Response.ContentType = "application/octet-stream";

  Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(fileName));

  Response.BinaryWrite(bytes);

  Response.Flush();

  Response.End();

  return new EmptyResult();

}  

要么生,要么死
原文地址:https://www.cnblogs.com/llljpf/p/6597124.html