导出时添加模板导出Excel

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.具体应用请至

http://npoi.codeplex.com/
http://epplus.codeplex.com/

C# NPOI vs EPPlus 导出Excel简单对比
c# 使用Interop.Excel.dll官方组件导出Excel（根据模板）