poi
poi copied to clipboard
Cell Styles are not updating
Hi, I set a cell alignment to the right & after setting the style to one cell I updated the alignment of a style to the left. But I'm getting both the cell's alignment left in the output. Could you help me to fix this?
`CellStyle style1 = wb.createCellStyle(); style1.setAlignment(CellStyle.ALIGN_RIGHT);
HSSFCell hssfCell = row1.createCell(j); String val = "200"; hssfCell.setCellValue(Integer.parseInt(val)); hssfCell.setCellStyle(style1);
HSSFCell hssfCell2 = row1.createCell(j); val = "300"; hssfCell2.setCellValue(Integer.parseInt(val)); style1.setAlignment(CellStyle.ALIGN_LEFT); hssfCell2.setCellStyle(style1);`
Thanks in advance