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