NPOI复制模板另存为新的excel

使用NPOI组件

 

 

excel类

引用

using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using NPOI.SS.Util;
using NPOI.XSSF.UserModel;
using System.IO;

#region 正式导出无bug
    public HSSFWorkbook DataTableToExcelOK(DataTable dt, DataTable dt1, DataTable dt2, string filePath, string tpath, bool isColumnName)
    {
       
        IRow row = null;
        ISheet sheet = null;
        ICell cell = null;
        int startRow = 0;
        IWorkbook workbook = null;
        FileInfo ff = new FileInfo(tpath);
        FileStream fs2 = null;

        if (ff.Exists)
        {
            ff.Delete();
        }
        FileStream fs = new FileStream(tpath, FileMode.Create, FileAccess.ReadWrite);
        HSSFWorkbook x1 = new HSSFWorkbook();
        x1.Write(fs);
        fs.Close();

        FileStream fileRead = new FileStream(filePath, FileMode.Open, FileAccess.Read);//打开模板
        HSSFWorkbook hssfworkbook = new HSSFWorkbook(fileRead);

        FileStream fileSave2 = new FileStream(tpath, FileMode.Open, FileAccess.Read);//打开新创建的excel
        HSSFWorkbook book2 = new HSSFWorkbook(fileSave2);

        HSSFSheet CPS = hssfworkbook.GetSheetAt(6) as HSSFSheet;//获取模板的sheet
        
        CPS.CopyTo(book2, "报价体系V1.5", true, true);//将模板复制到新建的excel中

        using (FileStream fileSave =