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();
}
