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 RepeaterFormatter<StudentInfo>(collection["Sheet1", "rptStudentInfo_Start"],collection["Sheet1", "rptStudentInfo_End"], StudentLogic.GetList(),
new RepeaterCellInfo<StudentInfo>(collection["Sheet1", "Name"], t => t.Name),
new RepeaterCellInfo<StudentInfo>(collection["Sheet1", "Gender"], t => t.Gender ? "男" : "女"),
new RepeaterCellInfo<StudentInfo>(collection["Sheet1", "Class"], t => t.Class),
new RepeaterCellInfo<StudentInfo>(collection["Sheet1", "RecordNo"], t => t.RecordNo),
new RepeaterCellInfo<StudentInfo>(collection["Sheet1", "Phone"], t => t.Phone),
new RepeaterCellInfo<StudentInfo>(collection["Sheet1", "Email"], t => t.Email)
));
//导出文件到本地
ExportHelper.ExportToLocal(@"Template\Template.xls", saveFileDlg.FileName,
new SheetFormatterContainer("Sheet1", formatters)
);
}
}
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");
List<ElementFormatter> sheet1Formatters = new List<ElementFormatter>();
sheet1Formatters.Add(new PartFormatter(collection["Sheet1", "Parameter"], "Parameter","World"));
List<ElementFormatter> sheet2Formatters = new List<ElementFormatter>();
sheet2Formatters.Add(new PartFormatter(collection["Sheet2", "Parameter"], "Parameter", "ExcelReport"));
//导出文件到本地
ExportHelper.ExportToLocal(@"Template\Template.xls", saveFileDlg.FileName,
new SheetFormatterContainer("Sheet1", sheet1Formatters),
new SheetFormatterContainer("Sheet2", sheet2Formatters)
);
}
}
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");
List<ElementFormatter> formatters = new List<ElementFormatter>();
formatters.Add(new CellFormatter(collection["Sheet1","String"],"Hello World!"));
formatters.Add(new CellFormatter(collection["Sheet1", "DateTime"], DateTime.Now));
formatters.Add(new CellFormatter(collection["Sheet1", "Boolean"], true));
formatters.Add(new CellFormatter(collection["Sheet1", "Double"], 3.14));
formatters.Add(new CellFormatter(collection["Sheet1", "Image"], Image.FromFile("Image/C#高级编程.jpg").ToBuffer()));
//导出文件到本地
ExportHelper.ExportToLocal(@"Template\Template.xls", saveFileDlg.FileName,
new SheetFormatterContainer("Sheet1", formatters)
);
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
ExcelReport.ParameterCollection collection = new ExcelReport.ParameterCollection();
collection.Load(Server.MapPath(@"Template\Template.xml"));
List <ElementFormatter> formatters = new List <ElementFormatter>();
formatters.Add(new CellFormatter(collection["GradeDetail", "Dept"], "某某学院"));
formatters.Add(new CellFormatter(collection["GradeDetail", "Class"], "某某班级"));
formatters.Add(new CellFormatter(collection["GradeDetail", "StudNo"], "2009*****"));
formatters.Add(new CellFormatter(collection["GradeDetail", "StudName"], "韩兆新"));
formatters.Add(new CellFormatter(collection["GradeDetail", "ExportDate"], DateTime.Now));
List <GradeInfo> gradeInfoList = new List <GradeInfo>();
gradeInfoList.Add(new GradeInfo()
{
CGPA = 18, CourseID = "KC-0001", CourseName = "高等数学", CourseType = "理论课", Credit = 6, EvaluationMode = "考试", GainCredit = 6, GPA = 3, Grade = 86, StudyNature = "初修", Type = "必修课"
});
gradeInfoList.Add(new GradeInfo()
{
CGPA = 2, CourseID = "KC-0002", CourseName = "计算机应用基础", CourseType = "理论课", Credit = 2, EvaluationMode = "考试", GainCredit = 2, GPA = 1, Grade = 93, StudyNature = "初修", Type = "必修课"
});
gradeInfoList.Add(new GradeInfo()
{
CGPA = 9, CourseID = "KC-0003", CourseName = "C程序设计", CourseType = "理论课", Credit = 3, EvaluationMode = "考试", GainCredit = 3, GPA = 3, Grade = 97, StudyNature = "初修", Type = "必修课", Remark = "备注信息"
});
formatters.Add(new TableFormatter <GradeInfo>(collection["GradeDetail", "CourseID"].X, gradeInfoList,
new TableColumnInfo <GradeInfo>(collection["GradeDetail", "CGPA"].Y, t => t.CGPA),
new TableColumnInfo <GradeInfo>(collection["GradeDetail", "CourseID"].Y, t => t.CourseID),
new TableColumnInfo <GradeInfo>(collection["GradeDetail", "CourseName"].Y, t => t.CourseName),
new TableColumnInfo <GradeInfo>(collection["GradeDetail", "CourseType"].Y, t => t.CourseType),
new TableColumnInfo <GradeInfo>(collection["GradeDetail", "Credit"].Y, t => t.Credit),
new TableColumnInfo <GradeInfo>(collection["GradeDetail", "EvaluationMode"].Y, t => t.EvaluationMode),
new TableColumnInfo <GradeInfo>(collection["GradeDetail", "GainCredit"].Y, t => t.GainCredit),
new TableColumnInfo <GradeInfo>(collection["GradeDetail", "GPA"].Y, t => t.GPA),
new TableColumnInfo <GradeInfo>(collection["GradeDetail", "Grade"].Y, t => t.Grade),
new TableColumnInfo <GradeInfo>(collection["GradeDetail", "Remark"].Y, t => t.Remark),
new TableColumnInfo <GradeInfo>(collection["GradeDetail", "StudyNature"].Y, t => t.StudyNature),
new TableColumnInfo <GradeInfo>(collection["GradeDetail", "Type"].Y, t => t.Type)
));
Export.ExportToWeb(Server.MapPath(@"Template\Template.xls"), "GradeDetail",
new SheetFormatterContainer("GradeDetail", formatters));
}
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");
List<ElementFormatter> formatters = new List<ElementFormatter>();
formatters.Add(new PartFormatter(collection["局部格式化器", "UserName"], "UserName", "Jensen"));
formatters.Add(new PartFormatter(collection["局部格式化器", "GroupNo"], "GroupNo", "116476496"));
//导出文件到本地
ExportHelper.ExportToLocal(@"Template\Template.xls", saveFileDlg.FileName,
new SheetFormatterContainer("局部格式化器", formatters)
);
}
}
public static ParameterCollection Parse(string templatePath)
{
ParameterCollection workbookParameter = new ParameterCollection();
IWorkbook workbook = NPOIHelper.LoadWorkbook(templatePath);
foreach (ISheet sheet in workbook)
{
foreach (IRow row in sheet)
{
foreach (ICell cell in row.Cells)
{
if (cell.CellType.Equals(CellType.String))
{
string cellText = cell.StringCellValue;
MatchCollection matches = new Regex(@"(?<=\$\[)([\w]*)(?=\])").Matches(cellText);
foreach (Match match in matches)
{
workbookParameter[sheet.SheetName, match.Value] = new Point(cell.RowIndex, cell.ColumnIndex);
}
}
}
}
}
return workbookParameter;
}
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\演示：工资条模板.xml");
List<ElementFormatter> payTableFormatters = new List<ElementFormatter>();
payTableFormatters.Add(new PartFormatter(collection["工资表", "Dept"], "Dept", "生产A部"));
payTableFormatters.Add(new CellFormatter(collection["工资表", "Month"], "2015年4月"));
payTableFormatters.Add(new TableFormatter<SalaryInfo>(collection["工资表", "JobNo"].X, SalaryInfoLogic.GetList(),
new TableColumnInfo<SalaryInfo>(collection["工资表", "JobNo"].Y, t => t.JobNo),
new TableColumnInfo<SalaryInfo>(collection["工资表", "Name"].Y, t => t.Name),
new TableColumnInfo<SalaryInfo>(collection["工资表", "HourlyWage"].Y, t => t.HourlyWage),
new TableColumnInfo<SalaryInfo>(collection["工资表", "ManHour"].Y, t => t.ManHour),
new TableColumnInfo<SalaryInfo>(collection["工资表", "UsualOvertime"].Y, t => t.UsualOvertime),
new TableColumnInfo<SalaryInfo>(collection["工资表", "WeekendOvertime"].Y, t => t.WeekendOvertime),
new TableColumnInfo<SalaryInfo>(collection["工资表", "LegalOvertime"].Y, t => t.LegalOvertime),
new TableColumnInfo<SalaryInfo>(collection["工资表", "BasePay"].Y, t => t.BasePay),
new TableColumnInfo<SalaryInfo>(collection["工资表", "OvertimePay"].Y, t => t.OvertimePay),
new TableColumnInfo<SalaryInfo>(collection["工资表", "FoodAllowance"].Y, t => t.FoodAllowance),
new TableColumnInfo<SalaryInfo>(collection["工资表", "OtherAllowance"].Y, t => t.OtherAllowance),
new TableColumnInfo<SalaryInfo>(collection["工资表", "GrossPay"].Y, t => t.GrossPay),
new TableColumnInfo<SalaryInfo>(collection["工资表", "BoardWages"].Y, t => t.BoardWages),
new TableColumnInfo<SalaryInfo>(collection["工资表", "Utilities"].Y, t => t.Utilities),
new TableColumnInfo<SalaryInfo>(collection["工资表", "BadDebt"].Y, t => t.BadDebt),
new TableColumnInfo<SalaryInfo>(collection["工资表", "RealWages"].Y, t => t.RealWages),
new TableColumnInfo<SalaryInfo>(collection["工资表", "Remark"].Y, t => t.Remark)
));
List<ElementFormatter> payStripFormatters = new List<ElementFormatter>();
payStripFormatters.Add(new RepeaterFormatter<SalaryInfo>(collection["工资条", "rptPaySlipStart"], collection["工资条", "rptPaySlipEnd"], SalaryInfoLogic.GetList(),
new RepeaterCellInfo<SalaryInfo>(collection["工资条", "Title"], t => "某工厂生产A部工资条"),
new RepeaterCellInfo<SalaryInfo>(collection["工资条", "Month"], t => "2015年4月"),
new RepeaterCellInfo<SalaryInfo>(collection["工资条", "JobNo"], t => t.JobNo),
new RepeaterCellInfo<SalaryInfo>(collection["工资条", "Name"], t => t.Name),
new RepeaterCellInfo<SalaryInfo>(collection["工资条", "HourlyWage"], t => t.HourlyWage),
new RepeaterCellInfo<SalaryInfo>(collection["工资条", "ManHour"], t => t.ManHour),
new RepeaterCellInfo<SalaryInfo>(collection["工资条", "UsualOvertime"], t => t.UsualOvertime),
new RepeaterCellInfo<SalaryInfo>(collection["工资条", "WeekendOvertime"], t => t.WeekendOvertime),
new RepeaterCellInfo<SalaryInfo>(collection["工资条", "LegalOvertime"], t => t.LegalOvertime),
new RepeaterCellInfo<SalaryInfo>(collection["工资条", "BasePay"], t => t.BasePay),
new RepeaterCellInfo<SalaryInfo>(collection["工资条", "OvertimePay"], t => t.OvertimePay),
new RepeaterCellInfo<SalaryInfo>(collection["工资条", "FoodAllowance"], t => t.FoodAllowance),
new RepeaterCellInfo<SalaryInfo>(collection["工资条", "OtherAllowance"], t => t.OtherAllowance),
new RepeaterCellInfo<SalaryInfo>(collection["工资条", "GrossPay"], t => t.GrossPay),
new RepeaterCellInfo<SalaryInfo>(collection["工资条", "BoardWages"], t => t.BoardWages),
new RepeaterCellInfo<SalaryInfo>(collection["工资条", "Utilities"], t => t.Utilities),
new RepeaterCellInfo<SalaryInfo>(collection["工资条", "BadDebt"], t => t.BadDebt),
new RepeaterCellInfo<SalaryInfo>(collection["工资条", "RealWages"], t => t.RealWages),
new RepeaterCellInfo<SalaryInfo>(collection["工资条", "Remark"], t => t.Remark)
));
//导出文件到本地
ExportHelper.ExportToLocal(@"Template\演示：工资条模板.xlsx", saveFileDlg.FileName,
new SheetFormatterContainer("工资表", payTableFormatters),
new SheetFormatterContainer("工资条", payStripFormatters)
);
}
}