下面我主要用List 实体类集合
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(@"modelAllWarehousing.xls"));
break;
case "上货开箱信息":
designer.Open(Server.MapPath(@"modelWarehousing.xls"));
break;
case "检品之后信息":
designer.Open(Server.MapPath(@"modelDress_Jp.xls"));
break;
case "检针之后信息":
designer.Open(Server.MapPath(@"modelDress_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 读取数据
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();
