使用ExcelReport导出Excel.docx

示例（导出学生成绩明细）步骤一：设计Excel模板首先，使用Excel软件设计模板（我没有安装MSOffice，用LibreOffice Calc做的演示）。在模板中要填充数据的位置用$ParameterName代替。步骤二：生成模板填充规则文件使用模板填充规则文件生成工具（ERTool）为步骤一设计的Excel模板生成填充规则文件。步骤三：为模板填充数据实现代码(导出到本地)：/实例化一个参数容器，并加载模板填充规则文件ParameterCollection collection = new ParameterCollection();collection.Load(TemplateTemplate.xml);/实例化一个元素格式化器列表List formatters = new List();formatters.Add(new CellFormatter(collectionGradeDetail, Dept, 某某学院); /添加一个单元格格式化器formatters.Add(new CellFormatter(collectionGradeDetail, Class, 某某班级);formatters.Add(new CellFormatter(collectionGradeDetail, StudNo, 2009*);formatters.Add(new CellFormatter(collectionGradeDetail, StudName, 韩兆新);formatters.Add(new CellFormatter(collectionGradeDetail, ExportDate, DateTime.Now);List gradeInfoList = new List();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 = 备注信息 );/添加一个Table格式化器formatters.Add(new TableFormatter(collectionGradeDetail, CourseID.X, gradeInfoList, new TableColumnInfo(collectionGradeDetail, CGPA.Y, t = t.CGPA), new TableColumnInfo(collectionGradeDetail, CourseID.Y, t = t.CourseID), new TableColumnInfo(collectionGradeDetail, CourseName.Y, t = t.CourseName), new TableColumnInfo(collectionGradeDetail, CourseType.Y, t = t.CourseType), new TableColumnInfo(collectionGradeDetail, Credit.Y, t = t.Credit), new TableColumnInfo(collectionGradeDetail, EvaluationMode.Y, t = t.EvaluationMode), new TableColumnInfo(collectionGradeDetail, GainCredit.Y, t = t.GainCredit), new TableColumnInfo(collectionGradeDetail, GPA.Y, t = t.GPA), new TableColumnInfo(collectionGradeDetail, Grade.Y, t = t.Grade), new TableColumnInfo(collectionGradeDetail, Remark.Y, t = t.Remark), new TableColumnInfo(collectionGradeDetail, StudyNature.Y, t = t.StudyNature), new TableColumnInfo(collectionGradeDetail, Type.Y, t = t.Type) );/导出文件到本地Export.ExportToLocal(TemplateTemplate.xls, saveFileDlg.FileName, new SheetFormatterContainer(GradeDetail, formatters);实现代码(导出到Web)：/实例化一个参数容器，并加载模板填充规则文件ExcelReport.ParameterCollection collection = new ExcelReport.ParameterCollection();collection.Load(Server.MapPath(TemplateTemplate.xml);/实例化一个元素格式化器列表List formatters = new List();formatters.Add(new CellFormatter(collectionGradeDetail, Dept, 某某学院); /添加一个单元格格式化器formatters.Add(new CellFormatter(collectionGradeDetail, Class, 某某班级);formatters.Add(new CellFormatter(collectionGradeDetail, StudNo, 2009*);formatters.Add(new CellFormatter(collectionGradeDetail, StudName, 韩兆新);formatters.Add(new CellFormatter(collectionGradeDetail, ExportDate, DateTime.Now);List gradeInfoList = new List();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 = 备注信息 );/添加一个Table格式化器formatters.Add(new TableFormatter(collectionGradeDetail, CourseID.X, gradeInfoList, new TableColumnInfo(collectionGradeDetail, CGPA.Y, t = t.CGPA), new TableColumnInfo(collectionGradeDetail, CourseID.Y, t = t.CourseID), new TableColumnInfo(collectionGradeDetail, CourseName.Y, t = t.CourseName), new TableColumnInfo(collectionGradeDetail, CourseType.Y, t = t.CourseType), new TableColumnInfo(collectionGradeDetail, Credit.Y, t = t.Credit), new TableColumnInfo(collectionGradeDetail, EvaluationMode.Y, t = t.EvaluationMode), new TableColumnInfo(collectionGradeDetail, GainCredit.Y, t = t.GainCredit), new TableColumnInfo(collectionGradeDetail, GPA.Y, t = t.GPA), new TableColumnInfo(collectionGradeDetail, Grade.Y, t = t.Grade), new TableColumnInfo(collectionGradeDetail, Remark.Y, t = t.Remark), new TableColumnInfo(collectionGradeDetail,