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]); //創建一個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; }  //設置實體類對象<span style="color:#FF0000;">這里設置了Export 變量，然后在模板里面我們就用了。 designer.SetDataSource("Export", getJianPinOrZhenData); //報表標題頭部 //可以擴展多個designer.SetDataSource("ExportUtils",strParm[4]); //報表截止日期 designer.SetDataSource("ExportDate", DateTime.Now.ToString("yyyy年MM月dd日"));//根據數據源處理生成報表內容 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>);//設置DataTable對象designer.SetDataSource("Export",dt); //設置DataSet對象designer.SetDataSource(ds.Tables["Export"]);designer.Process();