从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; 

 }