使用ExcelReport導(dǎo)出Excel.docx

示例（導(dǎo)出學(xué)生成績(jī)明細(xì)）步驟一：設(shè)計(jì)Excel模板首先，使用Excel軟件設(shè)計(jì)模板（我沒有安裝MSOffice，用LibreOffice Calc做的演示）。在模板中要填充數(shù)據(jù)的位置用$ParameterName代替。步驟二：生成模板填充規(guī)則文件使用模板填充規(guī)則文件生成工具（ERTool）為步驟一設(shè)計(jì)的Excel模板生成填充規(guī)則文件。步驟三：為模板填充數(shù)據(jù)實(shí)現(xiàn)代碼(導(dǎo)出到本地)：/實(shí)例化一個(gè)參數(shù)容器，并加載模板填充規(guī)則文件ParameterCollection collection = new ParameterCollection();collection.Load(TemplateTemplate.xml);/實(shí)例化一個(gè)元素格式化器列表List formatters = new List();formatters.Add(new CellFormatter(collectionGradeDetail, Dept, 某某學(xué)院); /添加一個(gè)單元格格式化器formatters.Add(new CellFormatter(collectionGradeDetail, Class, 某某班級(jí));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 = 高等數(shù)學(xué), CourseType = 理論課, Credit = 6, EvaluationMode = 考試, GainCredit = 6, GPA = 3, Grade = 86, StudyNature = 初修, Type = 必修課 );gradeInfoList.Add(new GradeInfo() CGPA = 2, CourseID = KC-0002, CourseName = 計(jì)算機(jī)應(yīng)用基礎(chǔ), CourseType = 理論課, Credit = 2, EvaluationMode = 考試, GainCredit = 2, GPA = 1, Grade = 93, StudyNature = 初修, Type = 必修課 );gradeInfoList.Add(new GradeInfo() CGPA = 9, CourseID = KC-0003, CourseName = C程序設(shè)計(jì), CourseType = 理論課, Credit = 3, EvaluationMode = 考試, GainCredit = 3, GPA = 3, Grade = 97, StudyNature = 初修, Type = 必修課, Remark = 備注信息 );/添加一個(gè)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) );/導(dǎo)出文件到本地Export.ExportToLocal(TemplateTemplate.xls, saveFileDlg.FileName, new SheetFormatterContainer(GradeDetail, formatters);實(shí)現(xiàn)代碼(導(dǎo)出到Web)：/實(shí)例化一個(gè)參數(shù)容器，并加載模板填充規(guī)則文件ExcelReport.ParameterCollection collection = new ExcelReport.ParameterCollection();collection.Load(Server.MapPath(TemplateTemplate.xml);/實(shí)例化一個(gè)元素格式化器列表List formatters = new List();formatters.Add(new CellFormatter(collectionGradeDetail, Dept, 某某學(xué)院); /添加一個(gè)單元格格式化器formatters.Add(new CellFormatter(collectionGradeDetail, Class, 某某班級(jí));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 = 高等數(shù)學(xué), CourseType = 理論課, Credit = 6, EvaluationMode = 考試, GainCredit = 6, GPA = 3, Grade = 86, StudyNature = 初修, Type = 必修課 );gradeInfoList.Add(new GradeInfo() CGPA = 2, CourseID = KC-0002, CourseName = 計(jì)算機(jī)應(yīng)用基礎(chǔ), CourseType = 理論課, Credit = 2, EvaluationMode = 考試, GainCredit = 2, GPA = 1, Grade = 93, StudyNature = 初修, Type = 必修課 );gradeInfoList.Add(new GradeInfo() CGPA = 9, CourseID = KC-0003, CourseName = C程序設(shè)計(jì), CourseType = 理論課, Credit = 3, EvaluationMode = 考試, GainCredit = 3, GPA = 3, Grade = 97, StudyNature = 初修, Type = 必修課, Remark = 備注信息 );/添加一個(gè)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,