|
@@ 177-188 (lines=12) @@
|
| 174 |
|
cell.setCellFormula(null); |
| 175 |
|
} |
| 176 |
|
|
| 177 |
|
private void fillCell(XSSFSheet sheet, int columnNumber, int rowNumber, Integer value) { |
| 178 |
|
XSSFRow row = sheet.getRow(rowNumber); |
| 179 |
|
XSSFCell cell = row.getCell(columnNumber); |
| 180 |
|
if (cell == null) { |
| 181 |
|
cell = row.createCell(columnNumber, NUMERIC); |
| 182 |
|
} |
| 183 |
|
if (value == null) { |
| 184 |
|
cell.setCellValue(""); |
| 185 |
|
} else { |
| 186 |
|
cell.setCellValue(value); |
| 187 |
|
} |
| 188 |
|
cell.setCellFormula(null); |
| 189 |
|
} |
| 190 |
|
|
| 191 |
|
private String round(Float value) { |
|
@@ 167-174 (lines=8) @@
|
| 164 |
|
return value == null ? null : Integer.parseInt(value); |
| 165 |
|
} |
| 166 |
|
|
| 167 |
|
private void fillCell(XSSFSheet sheet, int columnNumber, int rowNumber, String value) { |
| 168 |
|
XSSFRow row = sheet.getRow(rowNumber); |
| 169 |
|
XSSFCell cell = row.getCell(columnNumber); |
| 170 |
|
if (cell == null) { |
| 171 |
|
cell = row.createCell(columnNumber); |
| 172 |
|
} |
| 173 |
|
cell.setCellValue(value == null ? "" : value); |
| 174 |
|
cell.setCellFormula(null); |
| 175 |
|
} |
| 176 |
|
|
| 177 |
|
private void fillCell(XSSFSheet sheet, int columnNumber, int rowNumber, Integer value) { |