Untitled
unknown
plain_text
2 years ago
2.6 kB
6
Indexable
private void stRepOne(List<Map<String, Object>> duData, XSSFCellStyle h11, int startRow, String iOUName, ResourceBundle rb, XSSFSheet hssfSheet, CellStyle style, Set<String> keys2) { for (int l = 0; l < duData.size(); l++) { hssfSheet.createRow(startRow + l); int j = 0; for (String key1 : keys2) { XSSFCell cell = hssfSheet.getRow(startRow + l).createCell(j); splDuOne(duData, h11, style, l, j, key1, cell); cell.setCellStyle(h11); j++; duPlSecLast(duData, startRow, rb, hssfSheet, style, l, j); } splDuLast(duData, startRow, iOUName, rb, hssfSheet, l); } } private void duPlSecLast(List<Map<String, Object>> duData, int startRow, ResourceBundle rb, XSSFSheet hssfSheet, CellStyle style, int l, int j) { if (j == 19) { newSplThree(duData, startRow, rb, style, hssfSheet, l, j); } } private void splDuLast(List<Map<String, Object>> duData, int startRow, String iOUName, ResourceBundle rb, XSSFSheet hssfSheet, int l) { if (duData.size() - 1 == l && null != iOUName) { XSSFRow totalRow = hssfSheet.createRow(startRow + l + 1); XSSFCell cll = null; cll = totalRow.createCell(0); cll.setCellValue(duData.size()); cll = totalRow.createCell(1); cll.setCellValue(LiteralConstants.TOTAL); hssfSheet.addMergedRegion(new CellRangeAddress(startRow + l + 1, startRow + l + 1, 1, 8)); cll = totalRow.createCell(10); cll.setCellType(HSSFCell.CELL_TYPE_FORMULA); cll.setCellFormula( LiteralConstants.SUMK + (startingRowNo + 1) + ":K" + (duData.size() + startingRowNo) + ")"); cll = totalRow.createCell(11); cll.setCellType(HSSFCell.CELL_TYPE_FORMULA); cll.setCellFormula( LiteralConstants.SUML + (startingRowNo + 1) + ":L" + (duData.size() + startingRowNo) + ")"); cll = totalRow.createCell(12); cll.setCellType(HSSFCell.CELL_TYPE_FORMULA); cll.setCellFormula( LiteralConstants.SUMM + (startingRowNo + 1) + ":M" + (duData.size() + startingRowNo) + ")"); cll = totalRow.createCell(13); cll.setCellType(HSSFCell.CELL_TYPE_FORMULA); cll.setCellFormula( LiteralConstants.SUM_N + (startingRowNo + 1) + ":N" + (duData.size() + startingRowNo) + ")"); cll = totalRow.createCell(14); cll.setCellType(HSSFCell.CELL_TYPE_FORMULA); cll.setCellFormula( LiteralConstants.SUM_O + (startingRowNo + 1) + ":O" + (duData.size() + startingRowNo) + ")"); } In the above code I'm getting SAST error that Dead Code: Expression is Always false for "if (duData.size() - 1 == l && null != iOUName)" can you modify the above code and give me solution
Editor is loading...
Leave a Comment