private void btnExport_Click(object sender, EventArgs e)
{
var saveFileDlg = new SaveFileDialog {
Filter = Resources.SaveFileFilter
};
if (DialogResult.OK.Equals(saveFileDlg.ShowDialog()))
{
var workbookParameterContainer = new WorkbookParameterContainer();
workbookParameterContainer.Load(@"Template\Template.xml");
SheetParameterContainer sheetParameterContainer = workbookParameterContainer["表格格式化器"];
int num = 0;
ExportHelper.ExportToLocal(@"Template\Template.xls", saveFileDlg.FileName,
new SheetFormatter("表格格式化器",
new TableFormatter <StudentInfo>(sheetParameterContainer["No"], StudentLogic.GetList(),
new CellFormatter <StudentInfo>(sheetParameterContainer["No"], t => num++),
new CellFormatter <StudentInfo>(sheetParameterContainer["Name"], t => t.Name),
new CellFormatter <StudentInfo>(sheetParameterContainer["Gender"], t => t.Gender ? "男" : "女"),
new CellFormatter <StudentInfo>(sheetParameterContainer["Class"], t => t.Class),
new CellFormatter <StudentInfo>(sheetParameterContainer["RecordNo"], t => t.RecordNo),
new CellFormatter <StudentInfo>(sheetParameterContainer["Phone"], t => t.Phone),
new CellFormatter <StudentInfo>(sheetParameterContainer["Email"], t => t.Email)
)
)
);
}
}
private void btnExport_Click(object sender, EventArgs e)
{
SaveFileDialog saveFileDlg = new SaveFileDialog();
saveFileDlg.Filter = "Excel 2003文件|*.xls|Excel 2007文件|*.xlsx";
if (DialogResult.OK.Equals(saveFileDlg.ShowDialog()))
{
ParameterCollection collection = new ParameterCollection();
collection.Load(@"Template\Template.xml");
int num = 0;
List <ElementFormatter> formatters = new List <ElementFormatter>();
formatters.Add(new TableFormatter <StudentInfo>(collection["Sheet1", "No"].X, StudentLogic.GetList(),
new TableColumnInfo <StudentInfo>(collection["Sheet1", "No"].Y, t => num++),
new TableColumnInfo <StudentInfo>(collection["Sheet1", "Name"].Y, t => t.Name),
new TableColumnInfo <StudentInfo>(collection["Sheet1", "Gender"].Y, t => t.Gender ? "男" : "女"),
new TableColumnInfo <StudentInfo>(collection["Sheet1", "Class"].Y, t => t.Class),
new TableColumnInfo <StudentInfo>(collection["Sheet1", "RecordNo"].Y, t => t.RecordNo),
new TableColumnInfo <StudentInfo>(collection["Sheet1", "Phone"].Y, t => t.Phone),
new TableColumnInfo <StudentInfo>(collection["Sheet1", "Email"].Y, t => t.Email)
));
//导出文件到本地
ExportHelper.ExportToLocal(@"Template\Template.xls", saveFileDlg.FileName,
new SheetFormatterContainer("Sheet1", formatters)
);
}
}
