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名称";
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实例