效果图: 前台调用:using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebCont ...
效果图:
前台调用:
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
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。