利用Aspose.Cells和Excel模板導(dǎo)出統(tǒng)計數(shù)據(jù)

protected void ExportExcel_ServerClick(object sender, EventArgs e)
 {
 HttpCookie getCookies = Request.Cookies["UserLogin"];
 if (getCookies != null)
 {
 string[] strParm = hfExcelData.Value.Split(',');
 List<jianpinorzhen_view> getJianPinOrZhenData = SearchExportData.LstSearchExportJianPinOrZhen
(Server.UrlDecode(getCookies["SqlConString"]), getCookies["CustomCode"],getCookies["CustomType"],
 strParm[0], strParm[1], strParm[2], strParm[3], strParm[4]);
 //創(chuàng)建一個workbookdesigner對象
 WorkbookDesigner designer = new WorkbookDesigner();
 
 //制定報表模板
 switch (strParm[4])
 {
 case "工廠入貨箱單信息":
  designer.Open(Server.MapPath(@"model\AllWarehousing.xls"));
 break;
 case "上貨開箱信息":
 designer.Open(Server.MapPath(@"model\Warehousing.xls"));
 break;
 case "檢品之后信息":
 designer.Open(Server.MapPath(@"model\Dress_Jp.xls"));
 break;
 case "檢針之后信息":
 designer.Open(Server.MapPath(@"model\Dress_Jz.xls"));
 break;
 default:
 break;
 }
 
 //設(shè)置實體類對象<span >這里設(shè)置了Export 變量，然后在模板里面我們就用了。
 designer.SetDataSource("Export", getJianPinOrZhenData);
 //報表標(biāo)題頭部 //可以擴展多個
designer.SetDataSource("ExportUtils",strParm[4]); 
//報表截止日期 
designer.SetDataSource("ExportDate", DateTime.Now.ToString("yyyy年MM月dd日"));
//根據(jù)數(shù)據(jù)源處理生成報表內(nèi)容
 designer.Process(); 
//客戶端保存的文件名//如果保存的文件名是漢字的話一定要編碼，否則就是亂碼 HttpUtility.UrlEncode(strParm[4])
string fileName = HttpUtility.UrlEncode(strParm[4]) + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"; 
designer.Save(fileName, SaveType.OpenInExcel, FileFormatType.Excel2003, Response); 
Response.Flush(); 
Response.Close();
designer = null;
Response.End(); }}

DataTable dt = ExcuteDataTable(querySql);
  
  dt.TableName = "Export";
  if (dt.Rows.Count == 0)
  return;
  WorkbookDesigner designer = new WorkbookDesigner();
string fileName = HttpUtility.UrlEncode(strParm[4]) + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
  designer.Open(fileName<code class="csharp spaces"></code>);
//設(shè)置DataTable對象
designer.SetDataSource("Export",dt); 
//設(shè)置DataSet對象
designer.SetDataSource(ds.Tables["Export"]);
designer.Process();