POISXSSFWorkbook读取模板存在公式解决

1、POISXSSFWorkbook读取模板存在公式解决kagceom.baoqilai.base.serviceorjtavo.Fiorjtavo.FileInputStreorjtavorjtavIterator;orjtavorjtavorotrg.poi.ss.usermodeorotrg.poi.ss.usermodeorotrg.poi.ss.usermodeorotrg.poi.ss.usermodeorotrg.poi.ss.usermodeorotrg.poi.xssf.streamorotrg.poi.xssf.streamorotrg.poi.xssf.usermoorcto

2、m.baoorctom.baoeptioorctom.baoi.scp.servorctom.baoi.scp.servorellStyle;ataFormat;ow;.SXSSFSheet.SXSSFWorkbook.XSSFWorkbook;BaseException;ort.ExcelExportSerort.ExcelExportStr模*板导出*authlorlblcilcasTsemplateExporitmSeprlveimceEnxIm模板地*址rotectSterdingtempAddress;模板结*果集rotectSterdingresult;ubliTcemplteEx

3、portServiceImpsup(e)r;ddress=tempAddrth.iressult=result;ortSerStringtempAddress,StringrOverridebliSXcSSFWorkbookexport(List<Map<Sttrihnrogw,BsaOsbejEexccte>p>tidoantaongstime=System.currentTrynewFilFei(lteemfpiAd=dress);FinlewInFipluetISntpreuatmStriesXSSnFeWworXkSbSoFoWkorwkboo=k(is获取模板

4、中最后一行，用于判断是否存在公式intlastRowNum=wb.getSheeastRowNum(Shwb.getSheetARowbaseRow0=sheet0.getRow(2stRowNum=wb.getSheetAt(RowNup<InntewgHear,shSMtarpifor(Iterator<Cell>it=baseRow0.cellIterator();iCellbaseCeif(baseCel.CELL_TYPE_FORMUStringcellFormulabaseCellellForut(baseCell.getColumnIFor取到公式后进行删除bo

5、Sheetsheet=workbook.getSheetAt(0);CellStylecontextstyle=workbook.crDataFormatdf=workbook.createDataFormacontextstyle.setDataFormat(df.getForartRow=lastRowNum;ori(nti=startRow;+startRowintrowNtartRow;SXSSFWorkbodSXSSFWbldsriokbRowrow=sheet.getRow(i);if(row=null)row=sheet.createRow(i);Map<String,Ob

6、ject>dataMap=data.get(rowNum);StringcolumNames=result;dataMap.put("serialNum",rowNum+1);for(intj=0;j<columNames.length;j+)Cellcell=row.getCell(j);if(cell=null)cell=row.createCell(j);System.out.println(cell.getColumnIndex();Objectval=dataMap.get(columNamesj);ExcelUtil.setCellValue(cel

7、l,val,contextstyle);if(gsMap.get(cell.getColumnIndex()!=null)StringcellFormula=gsMap.get(cell.getColumnIndex();Strings=cellFormula.replaceAll("(w)d","$1"+(i+1);cell.setCellFormula(s);cell.setCellType(Cell.CELL_TYPE_FORMULA);dataMap.clear();/清空内存中缓存的行数if(i%500=0)(SXSSFSheet)sheet)

8、.flushRows();/数据清理data.clear();data=null;workbook.setForceFormulaRecalculation(true);/计算公式longetime=System.currentTimeMillis();System.out.println("处理写入模板数据启时："+(etime-stime)/1000);returnworkbook;catch(Exceptione)e.printStackTrace();returnnull;OverridepublicSXSSFWorkbookexportByStragegy(List<Map<String,Object>>data,ExcelExportStragystragegy)throwsBaseExceptionlongstime=System.