Question

C#操作excel，如何调用模板

Answer 1

<summary23///构造函数，需指定模板文件和输出文件完整路径24///
</summary25///
<paramname="templetFilePath"
Excel模板文件路径</param26///
<paramname="outputFilePath"
输出Excel文件路径</param27publicExcelHelper(stringtempletFilePath,
stringoutputFilePath)28{29if(templetFilePath==null)30thrownewException("Excel模板文件路径不能为空！");3132if(outputFilePath==null)33thrownewException("输出Excel文件路径不能为空！");3435if(!File.Exists(templetFilePath))36thrownewException("指定路径的Excel模板文件不存在！");3738this
.templetFile=templetFilePath;39this
.outputFile=outputFilePath;4041}4243///
<summary44///将DataTable数据写入Excel文件（套用模板并分页）45///
</summary46///

.GetSheetCount(rowCount,rows);//WorkSheet个数56DateTimebeforeTime;57DateTimeafterTime;5859if(sheetPrefixName==null||sheetPrefixName.Trim()=="")60sheetPrefixName="Sheet";6162//创建一个Application对象并使其可见63beforeTime=DateTime.Now;64Excel.Applicationapp=newExcel.ApplicationClass();65app.Visible=true;66afterTime=DateTime.Now;6768//打开模板文件，得到WorkBook对象69Excel.WorkbookworkBook=app.Workbooks.Open(templetFile,missing,missing,missing,missing,missing,70missing,missing,missing,missing,missing,missing,missing);7172//得到WorkSheet对象73Excel.WorksheetworkSheet=(Excel.Worksheet)workBook.Sheets.get_Item(1);7475//复制sheetCount-1个WorkSheet对象76for(inti=1;i<sheetCount;i++)77{78((Excel.Worksheet)workBook.Worksheets.get_Item(i)).Copy(missing,workBook.Worksheets[i]);79}8081#region将源DataTable数据写入Excel82for(inti=1;i<=sheetCount;i++)83{84intstartRow=(i-1)*rows;//记录起始行索引85intendRow=i*rows;//记录结束行索引8687//若是最后一个WorkSheet，那么记录结束行索引为源DataTable行数88if(i==sheetCount)89endRow=rowCount;9091//获取要写入数据的WorkSheet对象，并重命名92Excel.Worksheetsheet=(Excel.Worksheet)workBook.Worksheets.get_Item(i);93sheet.Name=sheetPrefixName+"-"+