Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2017
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.24 KB | None | 0 0
  1. Map<String, Object> properties = new HashMap<String, Object>();
  2. // Product Row
  3. List<Product> supplierProducts = DatabaseActivity.getAllProducts(DatabaseActivity.getSupplierByName(suppliersSpinner.getSelectedItem().toString()), null);
  4. int i = 0;
  5. while (i < supplierProducts.size()){
  6. sheet.createRow(PRODUCT_FIRST_ROW + 2 + i).createCell(PRODUCT_FIRST_COLUMN).setCellValue(supplierProducts.get(i).getName());
  7. CellUtil.setAlignment(sheet.getRow(PRODUCT_FIRST_ROW + 2 + i).getCell(PRODUCT_FIRST_COLUMN), wb, CellStyle.ALIGN_CENTER);
  8. properties.clear();
  9. properties.put(CellUtil.BORDER_LEFT, CellStyle.BORDER_MEDIUM);
  10. properties.put(CellUtil.BORDER_RIGHT, CellStyle.BORDER_THIN);
  11. int row = PRODUCT_FIRST_ROW + 2 + i;
  12. CellUtil.setCellStyleProperties(sheet.getRow(row).getCell(PRODUCT_FIRST_COLUMN), properties);
  13. i++;
  14. }
  15. properties.clear();
  16. properties.put(CellUtil.BORDER_BOTTOM, CellStyle.BORDER_MEDIUM);
  17. int row = PRODUCT_FIRST_ROW + 2 + i;
  18. CellUtil.setCellStyleProperties(sheet.getRow(row).getCell(PRODUCT_FIRST_COLUMN), properties);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement