从Excel模板获得需要导出的EXCEL文件的输入流方法

Java代码 public InputStream getExcelISForAs(List<Object> list) throws Exception { InputStream excelStream = null; FileInputStream fis = new FileInputStream(templatePath + "/template.xls"); HSSFWorkbook wb = new HSSFWorkbook(new POIFSFileSystem(fis)); fis.close(); dealExcel(list, wb);//此处修改填充EXCEL内容方法 ByteArrayOutputStream out = new ByteArrayOutputStream(); HSSFWorkbook hssWb = (HSSFWorkbook) wb; hssWb.write(out); excelStream = new ByteArrayInputStream(out.toByteArray()); out.close(); return excelStream; }