Apache POI coded formatting works with MS excel 2010 but not in excel 2003

Question

I have written code for color formatting for excel using Apache POI. The formatting for color and font came nicely in MS Excel 2010. But it does not have compatibility with excel 2003. The formatting is not there when the file opened in MS Excel 2003.

Here the sample code:

    CellStyle style = getWorkbook().createCellStyle();

    Font font = wb.createFont();
    font.setBoldweight(Font.BOLDWEIGHT_BOLD);
    font.setFontHeightInPoints((short)11);

    style.setFillForegroundColor(IndexedColors.GREY_50_PERCENT.getIndex());
    style.setFillPattern(CellStyle.SOLID_FOREGROUND);

    Cell cell = excelRow.createCell(10);
    cell.setCellStyle(style);

If any suggestions, let me know.

You are not using style.setFont, how come your defined font shows right in 2010? — Alfabravo, Aug 10 '12 at 14:49
@Alfabravo : I had used the style.setFont(font) in my original code. Since I cant put all the code here I trimmed some code. — undisputed, Aug 13 '12 at 08:23

score 1 · Answer 1 · edited May 23 '17 at 12:04

1

I had also faced same problem .it is nothing about excel version.We must create styles before the loop and apply styles to specific cells after creating.

https://stackoverflow.com/a/11792648/1211000(it might help )

edited May 23 '17 at 12:04

Community

1
1

answered Aug 16 '12 at 06:46

swamy

1,200
10
23

Apache POI coded formatting works with MS excel 2010 but not in excel 2003

1 Answers1