private void button2_Click(object sender, EventArgs e) { XtraReport1 report = new XtraReport1(); XtraReport2 report2 = new XtraReport2(); report.CreateDocument(false); report2.CreateDocument(false); report.ExportToXlsx("test1.xlsx", new DevExpress.XtraPrinting.XlsxExportOptions() { SheetName = "report1" }); report2.ExportToXlsx("test2.xlsx", new DevExpress.XtraPrinting.XlsxExportOptions() { SheetName = "report2" }); Workbook workbook = new DevExpress.Spreadsheet.Workbook(); workbook.LoadDocument("test1.xlsx"); Workbook workbook2 = new DevExpress.Spreadsheet.Workbook(); workbook2.LoadDocument("test2.xlsx"); workbook.Worksheets.Insert(1, "report2"); workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]); workbook.SaveDocument("test3.xlsx"); Process.Start("test3.xlsx"); }
private void button1_Click(object sender, EventArgs e) { XtraReport1 report = new XtraReport1(); report.CreateDocument(false); int addedPagesCount = 0; IDictionaryEnumerator items = report.Groups.GetEnumerator(); while (items.MoveNext()) { DictionaryEntry item = (DictionaryEntry)items.Current; int i = Convert.ToInt32(item.Value) + addedPagesCount; if (i % 2 == 0) { XtraReport2 emptyPage = new XtraReport2(); emptyPage.CreateDocument(false); addedPagesCount++; report.Pages.Insert(i + 1, emptyPage.Pages[0]); } } ReportPrintTool tool = new ReportPrintTool(report); tool.ShowPreviewDialog(); }
private void button1_Click(object sender, EventArgs e) { XtraReport1 report = new XtraReport1(); XtraReport2 report2 = new XtraReport2(); report.CreateDocument(false); report2.CreateDocument(false); report.Pages.AddRange(report2.Pages); ReportPrintTool tool = new ReportPrintTool(report); tool.ShowPreviewDialog(); }