T5750 / poi-repositories

:sunny: Read and Write Excel file using Java and Apache POI
https://poix.readthedocs.io
Apache License 2.0
323 stars 298 forks source link

Cell Styles are not updating #7

Open VineelaKantamneni opened 8 months ago

VineelaKantamneni commented 8 months ago

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

T5750 commented 8 months ago
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));
CellStyle style2 = wb.createCellStyle();
style2.setAlignment(CellStyle.ALIGN_LEFT);
hssfCell2.setCellStyle(style2);

Hi, I hope this can help you.