你的位置:首页 > 软件开发 > ASP.net > 使用aspose.cell动态导出多表头 EXCEL

使用aspose.cell动态导出多表头 EXCEL

发布时间:2015-09-10 02:00:18
效果图: 前台调用:using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebCont ...

效果图:

使用aspose.cell动态导出多表头 EXCEL

 

前台调用:

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data;using ExportCells;namespace WebApplication1{  public partial class _Default : System.Web.UI.Page  {    protected void Page_Load(object sender, EventArgs e)    {      /***********************参数赋值***********************/      //设置列      List<ExportCells.AsposeHelper.JqxTableColumns> columns = new List<ExportCells.AsposeHelper.JqxTableColumns>();      columns.Add(new ExportCells.AsposeHelper.JqxTableColumns() { text = "id" });      columns.Add(new ExportCells.AsposeHelper.JqxTableColumns() { text = "name", columngroup = "namesex" });      columns.Add(new ExportCells.AsposeHelper.JqxTableColumns() { text = "sex", columngroup = "namesex" });      columns.Add(new ExportCells.AsposeHelper.JqxTableColumns() { text = "id2" });      columns.Add(new ExportCells.AsposeHelper.JqxTableColumns() { text = "cat", columngroup = "Animal" });      columns.Add(new ExportCells.AsposeHelper.JqxTableColumns() { text = "dog", columngroup = "Animal" });      columns.Add(new ExportCells.AsposeHelper.JqxTableColumns() { text = "rabbit", columngroup = "Animal" });      columns.Add(new ExportCells.AsposeHelper.JqxTableColumns() { text = "id3" });      //设置分组      List<ExportCells.AsposeHelper.JqxTableColumnsGroup> group = new List<ExportCells.AsposeHelper.JqxTableColumnsGroup>();      group.Add(new ExportCells.AsposeHelper.JqxTableColumnsGroup() { name = "Animal", text = "动物" });      group.Add(new ExportCells.AsposeHelper.JqxTableColumnsGroup() { name = "namesex", text = "名字性别" });      //设置数据      DataTable dt = new DataTable();      dt.Columns.Add("id");      dt.Columns.Add("name");      dt.Columns.Add("sex");      dt.Columns.Add("id2");      dt.Columns.Add("cat");      dt.Columns.Add("dog");      dt.Columns.Add("rabbit");      dt.Columns.Add("id3");      var dr = dt.NewRow();      dr[0] = 0;      dr[1] = 1;      dr[2] = 2;      dr[3] = 3;      dr[4] = 4;      dr[5] = 5;      dr[6] = 6;      dr[7] = 7;      dt.Rows.Add(dr);      var dr2 = dt.NewRow();      dr2[0] = 10;      dr2[1] = 11;      dr2[2] = 12;      dr2[3] = 13;      dr2[4] = 14;      dr2[5] = 15;      dr2[6] = 16;      dr2[7] = 17;      dt.Rows.Add(dr2);      AsposeHelper.SaveColumnsHierarchy("1.xls", columns, group, dt);    }  }}

原标题:使用aspose.cell动态导出多表头 EXCEL

关键词:ASP

ASP
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。