My excel has lot of data. It consists of 3 sheets and all three sheets
have 300 rows with 15 columns. And we need all the rows and cells to
have the borders so that its readable. So I used following code snippet
for each cell.
HSSFCellStyle style = wb.createCellStyle();
style.setBorderTop(HSSFCellStyle.BORDER_THIN);
style.setTopBorderColor(HSSFColor.BLACK.index);
style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
style.setBottomBorderColor(HSSFColor.BLACK.index);
style.setBorderLeft(HSSFCellStyle.BORDER_THIN);
style.setLeftBorderColor(HSSFColor.BLACK.index);
style.setBorderRight(HSSFCellStyle.BORDER_THIN);
style.setRightBorderColor(HSSFColor.BLACK.index);
cell.setCellStyle(style);
When I create and format these cells POI does not complain anything. But
when I open the huge excel with that much formatting it complains "To
many different call formats".
Any idea how to get ride of this?
Thanks in advance.
Nidhi
