/
Form1.cs
49 lines (43 loc) · 1.78 KB
/
Form1.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using DevExpress.XtraReports.UI;
using DevExpress.Spreadsheet;
using System.Diagnostics;
namespace WindowsFormsApplication1 {
public partial class Form1 : Form {
public Form1() {
InitializeComponent();
}
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();
}
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");
}
}
}