Untitled
unknown
plain_text
2 years ago
2.6 kB
11
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