C# .NET导出时添加模板导出Excel
1.EPPlus
ExcelPackage package = new ExcelPackage(new FileInfo(@"D:\lvou.xlsx"))
2.NPOI
string TempletFileName = Server.MapPath("template.xls"); //模板路径
FileStream file = new FileStream(TempletFileName, FileMode.Open, FileAccess.Read);
HSSFWorkbook hssfworkbook = new HSSFWorkbook(file);
3.微软官方导出
Microsoft.Office.Interop.Excel.Workbooks workbooks = app.Workbooks;
Microsoft.Office.Interop.Excel._Workbook workbook = workbooks.Add(Server.MapPath(模板所在路径)); //加载模板
4.具体应用请至
C# NPOI vs EPPlus 导出Excel简单对比
c# 使用Interop.Excel.dll官方组件导出Excel(根据模板)