Untitled

 avatar
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