/
Form1.cs
40 lines (35 loc) · 1.52 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
#region #mailmerge1
using DevExpress.Spreadsheet;
using DevExpress.XtraBars.Ribbon;
using System.Collections.Generic;
namespace DXApplication1 {
public partial class Form1 : RibbonForm {
nwindDataSet dataSet;
nwindDataSetTableAdapters.CategoriesTableAdapter adapter;
IWorkbook template;
public Form1() {
InitializeComponent();
dataSet = new nwindDataSet();
adapter = new nwindDataSetTableAdapters.CategoriesTableAdapter();
adapter.Fill(dataSet.Categories);
}
private void Form1_Load(object sender, System.EventArgs e) {
spreadsheetControl1.LoadDocument("Documents\\MailMergeTemplate.xlsx");
template = spreadsheetControl1.Document;
template.MailMergeDataSource = dataSet;
template.MailMergeDataMember = "Categories";
}
#endregion #mailmerge1
#region #mailmerge2
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) {
IList<IWorkbook> resultWorkbooks = spreadsheetControl1.Document.GenerateMailMergeDocuments();
int index = 0;
foreach (IWorkbook workbook in resultWorkbooks) {
string fileName = string.Format("Documents\\SavedDocument{0}" + ".xlsx", index++);
workbook.SaveDocument(fileName, DocumentFormat.OpenXml);
}
System.Diagnostics.Process.Start("explorer.exe", "Documents\\");
}
#endregion #mailmerge2
}
}