poi导出excel报The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xl

最新推荐文章于 2026-06-18 16:58:06 发布

原创最新推荐文章于 2026-06-18 16:58:06 发布 · 4.6k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

java开发专栏收录该内容

11 篇文章

订阅专栏

在使用Apache POI库导出Excel时遇到错误：最大单元格样式数量超出限制，允许定义的最大样式数为4000。该问题源于 poi-3.8 版本中MAX_STYLES参数的限制。解决方法是修改 poi 源码，将 MAX_STYLES 值增大并重新编译 HSSFWorkBook 类，然后替换 poi-3.8.jar 中的相应 .class 文件。

poi导出excel报错：

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:1158)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.createCellStyle(HSSFWorkbook.java:76)
at core.tools.opration.xls.XlsManager.export(XlsManager.java:107)
at core.tools.opration.xls.XlsManager.export(XlsManager.java:40)
at creditcc.server.controller.CallSummaryServlet.doPost(CallSummaryServlet.java:132)
at creditcc.server.controller.CallSummaryServlet.doGet(CallSummaryServlet.java:55)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:362)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:729)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.handler.RequestLogHandler.handle(RequestLogHandler.java:49)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:829)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:513)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)