导入数据到模版并导出

       

    //模版
    var filePath = DirFileHelper.GetAbsolutePath("~/Resource/TemplateFile/");
    var TempletFileName = filePath + "车间产量登记导入模版.xlsx";

    FileStream file = new FileStream(TempletFileName, FileMode.Open, FileAccess.Read);
    //HSSFWorkbook hssfworkbook = new HSSFWorkbook(file);2003
    XSSFWorkbook hssfworkbook = new XSSFWorkbook(file);//2007
    
    ISheet sheet1 = hssfworkbook.GetSheet("sheet1");
    
    //创建一行数据
    IRow row = sheet1.CreateRow(1);
    //第一行第一列添加数据
    row.CreateCell(0).SetCellValue("value");
    //第一行第二列添加数据
    row.CreateCell(1).SetCellValue("value1");
       
     //下载
     string filename = "车间产量登记模版.xlsx";
     Response.AddHeader("Content-Disposition", "attachment;filename=" +
     HttpUtility.UrlEncode(filename, System.Text.Encoding.UTF8));
     //Response.ContentType = "application/octet-stream;charset=gbk";
     hssfworkbook.Write(Response.OutputStream);
     Response.End();