Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Map<String, Object> properties = new HashMap<String, Object>();
- // Product Row
- List<Product> supplierProducts = DatabaseActivity.getAllProducts(DatabaseActivity.getSupplierByName(suppliersSpinner.getSelectedItem().toString()), null);
- int i = 0;
- while (i < supplierProducts.size()){
- sheet.createRow(PRODUCT_FIRST_ROW + 2 + i).createCell(PRODUCT_FIRST_COLUMN).setCellValue(supplierProducts.get(i).getName());
- CellUtil.setAlignment(sheet.getRow(PRODUCT_FIRST_ROW + 2 + i).getCell(PRODUCT_FIRST_COLUMN), wb, CellStyle.ALIGN_CENTER);
- properties.clear();
- properties.put(CellUtil.BORDER_LEFT, CellStyle.BORDER_MEDIUM);
- properties.put(CellUtil.BORDER_RIGHT, CellStyle.BORDER_THIN);
- int row = PRODUCT_FIRST_ROW + 2 + i;
- CellUtil.setCellStyleProperties(sheet.getRow(row).getCell(PRODUCT_FIRST_COLUMN), properties);
- i++;
- }
- properties.clear();
- properties.put(CellUtil.BORDER_BOTTOM, CellStyle.BORDER_MEDIUM);
- int row = PRODUCT_FIRST_ROW + 2 + i;
- CellUtil.setCellStyleProperties(sheet.getRow(row).getCell(PRODUCT_FIRST_COLUMN), properties);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement