The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xls workbook

最新推荐文章于 2024-07-27 10:30:36 发布

工程师小A

最新推荐文章于 2024-07-27 10:30:36 发布

阅读量3.9k

点赞数 1

分类专栏： JAVA

原文链接：https://blog.csdn.net/johnstrive/article/details/8568113

版权

JAVA 专栏收录该内容

85 篇文章 0 订阅

订阅专栏

POI操作Excel中，导出的数据不是很大时，则不会有问题，而数据很多或者比较多时，

就会报以下的错误，是由于cell styles太多create造成，故一般可以把cellstyle设置放到循环外面

报错如下：

Caused by: java.lang.IllegalStateException: The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xls workbook
at org.apache.poi.hssf.usermodel.HSSFWorkbook.createCellStyle(HSSFWorkbook.java:1144)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.createCellStyle(HSSFWorkbook.java:88)
at com.trendmicro.util.toExcel.ExcelExporter.addWorkbook(ExcelExporter.java:712)
at com.trendmicro.util.toExcel.ExcelExporter.exportToExcel(ExcelExporter.java:212)

-------------示例--------------

错误示例


for (int i = 0; i < 20000; i++) {

    Row row = sheet.createRow(i); 

    Cell cell = row.createCell((short) 0); 

    CellStyle style = workbook.createCellStyle();

    Font font = workbook.createFont(); 

    font.setBoldweight(Font.BOLDWEIGHT_BOLD); 

    style.setFont(font); 

    cell.setCellStyle(style);

}

改正后正确代码


CellStyle style = workbook.createCellStyle();

Font font = workbook.createFont();

font.setBoldweight(Font.BOLDWEIGHT_BOLD);

style.setFont(font);

for (int i = 0; i < 20000; i++) { 

    Row row = sheet.createRow(i); 

    Cell cell = row.createCell((short) 0); 

    cell.setCellStyle(style);

}