导入数据到模版并导出

    //模版var filePath = DirFileHelper.GetAbsolutePath("~/Resource/TemplateFile/");var TempletFileName = filePath + "车间产量登记导入模版.xlsx";FileStream file = new FileStream(TempletFileName, FileMode.Open, FileAccess.Read);//HSSFWorkbook hssfworkbook = new HSSFWorkbook(file);2003XSSFWorkbook hssfworkbook = new XSSFWorkbook(file);//2007ISheet 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();