| Line 174... |
Line 174... |
| 174 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 1, 1));
|
174 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 1, 1));
|
| 175 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 2, 2));
|
175 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 2, 2));
|
| 176 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 3, 3));
|
176 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 3, 3));
|
| 177 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 4, 4));
|
177 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 4, 4));
|
| 178 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 5, 5));
|
178 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 5, 5));
|
| 179 |
sheet.trackAllColumnsForAutoSizing();
|
- |
|
| 180 |
|
179 |
|
| 181 |
int rowIndex = 0;
|
180 |
int rowIndex = 0;
|
| 182 |
Row rowHeader = sheet.createRow(rowIndex++);
|
181 |
Row rowHeader = sheet.createRow(rowIndex++);
|
| 183 |
Row rowPriceQuantity = sheet.createRow(rowIndex++);
|
182 |
Row rowPriceQuantity = sheet.createRow(rowIndex++);
|
| 184 |
int i=0;
|
183 |
int i=0;
|
| Line 191... |
Line 190... |
| 191 |
Cell cellStoreCodeHeader = rowHeader.createCell(i++);
|
190 |
Cell cellStoreCodeHeader = rowHeader.createCell(i++);
|
| 192 |
cellStoreCodeHeader.setCellValue("Store Code");
|
191 |
cellStoreCodeHeader.setCellValue("Store Code");
|
| 193 |
Cell cellStoreNameHeader = rowHeader.createCell(i++);
|
192 |
Cell cellStoreNameHeader = rowHeader.createCell(i++);
|
| 194 |
cellStoreNameHeader.setCellValue("Store Name");
|
193 |
cellStoreNameHeader.setCellValue("Store Name");
|
| 195 |
}
|
194 |
}
|
| - |
|
195 |
sheet.trackAllColumnsForAutoSizing();
|
| 196 |
Cell cellItemIdHeader = rowHeader.createCell(i++);
|
196 |
Cell cellItemIdHeader = rowHeader.createCell(i++);
|
| 197 |
cellItemIdHeader.setCellValue("Item Id");
|
197 |
cellItemIdHeader.setCellValue("Item Id");
|
| 198 |
Cell cellBrandHeader = rowHeader.createCell(i++);
|
198 |
Cell cellBrandHeader = rowHeader.createCell(i++);
|
| 199 |
cellBrandHeader.setCellValue("Brand");
|
199 |
cellBrandHeader.setCellValue("Brand");
|
| 200 |
Cell cellModelNameHeader = rowHeader.createCell(i++);
|
200 |
Cell cellModelNameHeader = rowHeader.createCell(i++);
|
| Line 226... |
Line 226... |
| 226 |
font.setBold(true);
|
226 |
font.setBold(true);
|
| 227 |
CellStyle cellStyle = workbook.createCellStyle();
|
227 |
CellStyle cellStyle = workbook.createCellStyle();
|
| 228 |
cellStyle.setFont(font);
|
228 |
cellStyle.setFont(font);
|
| 229 |
for (int j = 0; j < nonValueColumns + ((intervals.size()+1)) * 2; j++) {
|
229 |
for (int j = 0; j < nonValueColumns + ((intervals.size()+1)) * 2; j++) {
|
| 230 |
rowHeader.getCell(j).setCellStyle(cellStyle);
|
230 |
rowHeader.getCell(j).setCellStyle(cellStyle);
|
| 231 |
if (rowPriceQuantity.getCell(i) != null) {
|
231 |
if (rowPriceQuantity.getCell(j) != null) {
|
| 232 |
rowPriceQuantity.getCell(i).setCellStyle(cellStyle);
|
232 |
rowPriceQuantity.getCell(j).setCellStyle(cellStyle);
|
| 233 |
}
|
233 |
}
|
| 234 |
}
|
234 |
}
|
| 235 |
for (InventoryItemAgingModel inventoryItemAgingModel : inventoryItemAgingModels) {
|
235 |
for (InventoryItemAgingModel inventoryItemAgingModel : inventoryItemAgingModels) {
|
| 236 |
i=0;
|
236 |
i=0;
|
| 237 |
Row rowValues = sheet.createRow(rowIndex++);
|
237 |
Row rowValues = sheet.createRow(rowIndex++);
|