DEV中多个xtrareport导出excel,多个sheet页导出

report1.CreateLayoutViewDocument();
 report2.CreateLayoutViewDocument();
            report3.CreateLayoutViewDocument();
            report4.CreateLayoutViewDocument();
            report5.CreateLayoutViewDocument();
            report1.Pages.AddRange(report2.Pages)；
            report1.Pages.AddRange(report3.Pages);
            report1.Pages.AddRange(report4.Pages);
            report1.Pages.AddRange(report5.Pages);
            PrintingSystemBase ps = report1.PrintingSystem;
            ps.ContinuousPageNumbering = true;

            ps.ExportOptions.PrintPreview.DefaultFileName =“默认excel名称";
         
           

            ps.ExecCommand(DevExpress.XtraPrinting.PrintingSystemCommand.ExportXlsx);

其中report为xtrareport实例，本例导出五个sheet到一个excel文件，数据源为五个xtrareport实例