DevExpress导出多个Sheet页的Excel

以下代码在使用DevExpress控件时，可将不同的内容按Sheet页存放

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Windows.Forms;
using DevExpress.XtraPrinting;
using DevExpress.XtraPrintingLinks;

namespace DevWinApp
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();

            DataTable dt = new DataTable("test");
            dt.Columns.Add(new DataColumn("col1", typeof(string)));
            dt.Columns.Add(new DataColumn("col2", typeof(string)));
            dt.Columns.Add(new DataColumn("col3", typeof(string)));
            dt.Columns.Add(new DataColumn("col4", typeof(string)));
            for (int i = 0; i <= 6; i++)
            {
                DataRow dr = dt.NewRow();
                foreach (DataColumn dc in dt.Columns)
                {
                    dr[dc] = string.Format("行：{0},列:{1}", i + 1, dc.ColumnName);
                }
                dt.Rows.Add(dr);
                i++;
            }

            gridControl1.DataSource = dt.DefaultView;
            DevExpress.XtraPrinting.XlsxExportOptions xlsxExport = new DevExpress.XtraPrinting.XlsxExportOptions();
            gridView1.ExportToXlsx(@"E:\ExcelTest01.xlsx", xlsxExport);

            DataTable dt2 = dt.Copy();
            foreach (DataRow dr in dt2.Rows)
            {
                foreach (DataColumn dc in dt2.Columns)
                {
                    dr[dc] = string.Format("第二Sheet,", dr[dc]);
                }
            }
            gridControl2.DataSource = dt2.DefaultView;
            DevExpress.XtraGrid.GridControl[] grids = { gridControl1, gridControl2 };
            var defautps = new DevExpress.XtraPrinting.PrintingSystem();
            CompositeLink compLink = new CompositeLink(defautps);
            foreach (var gd in grids)
            {
                PrintableComponentLink pclink = new PrintableComponentLink();
                pclink.Component = gd;
                compLink.Links.Add(pclink);
            }

            #region 分Sheet
            //compLink.CreatePageForEachLink();  //用于每个Link生成一个Sheet,不使用此方法，则合并在一个Sheet内
            //compLink.ExportToXlsx(@"D:\DevExcel.xlsx", new XlsxExportOptions() { ExportMode = XlsxExportMode.SingleFilePageByPage });
            #endregion 分Sheet

            #region 放同一Sheet (须屏蔽 "分Sheet")
            compLink.ExportToXlsx(@"D:\DevExcel.xlsx");
            #endregion 放同一Sheet
        }
    }
}

 

转载于:https://www.cnblogs.com/todayhero/p/11120921.html