devexpress导出数据到excel，数据源为多个xtrareport时，多个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;


           


            ////report1.PrintingSystem.ExportOptions.PrintPreview.ShowOptionsBeforeExport = false;
            ps.ExportOptions.PrintPreview.DefaultFileName = TASKNAME + DateTime.Now.ToString("yyyyMMddHHmmss");
            //    //report1.PrintingSystem.ExecCommand(DevExpress.XtraPrinting.PrintingSystemCommand.SendXlsx);
           
            ps.ExecCommand(DevExpress.XtraPrinting.PrintingSystemCommand.ExportXlsx);