java.lang.IllegalArgumentException: Maximum number of fonts was exceeded解决

最新推荐文章于 2024-07-17 10:36:37 发布
最新推荐文章于 2024-07-17 10:36:37 发布
阅读量7.7k 收藏 1
点赞数 1
分类专栏： 一步一个java对象 文章标签： Excel导出 java 文字过多
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/gchere/article/details/70239447
版权

昨晚做数据Excel导出的时候报错，

java.lang.IllegalArgumentException: Maximum number of fonts was exceeded

    at org.apache.poi.hssf.usermodel.HSSFWorkbook.createFont(HSSFWorkbook.java:1068)
    at com.cxah.hfgj.common.util.excel.ExportExcel.exportExcel(ExportExcel.java:160)
    at com.cxah.hfgj.common.util.excel.ExportExcel.exportExcel(ExportExcel.java:52)
    at com.cxah.hfgj.common.util.excel.ExportExcel.excel(ExportExcel.java:214)
    at com.cxah.hfgj.service.imp.SurveyService.derivedExcel(SurveyService.java:143)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at com.sun.proxy.$Proxy76.derivedExcel(Unknown Source)
    at com.cxah.hfgj.web.admin.SurveyAction.edit(SurveyAction.java:67)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)
    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
    at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2517)
    at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2506)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:745)
java.lang.ArrayIndexOutOfBoundsException: -32747
    at java.util.ArrayList.elementData(ArrayList.java:400)
    at java.util.ArrayList.get(ArrayList.java:413)
    at org.apache.poi.hssf.model.WorkbookRecordList.get(WorkbookRecordList.java:50)
    at org.apache.poi.hssf.model.InternalWorkbook.getFontRecordAt(InternalWorkbook.java:481)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.getFontAt(HSSFWorkbook.java:1130)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.createFont(HSSFWorkbook.java:1073)
    at com.cxah.hfgj.common.util.excel.ExportExcel.exportExcel(ExportExcel.java:160)
    at com.cxah.hfgj.common.util.excel.ExportExcel.exportExcel(ExportExcel.java:52)
    at com.cxah.hfgj.common.util.excel.ExportExcel.excel(ExportExcel.java:214)
    at com.cxah.hfgj.service.imp.SurveyService.derivedExcel(SurveyService.java:143)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at com.sun.proxy.$Proxy76.derivedExcel(Unknown Source)
    at com.cxah.hfgj.web.admin.SurveyAction.edit(SurveyAction.java:67)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)

    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

网上查了一下

因为当时导出的记录，每条记录中汉字比较多。

HSSFFont font3 = workbook.createFont();
 font3.setColor(HSSFColor.BLUE.index);

这两句写在循环体中，没循环都要重新生成一次，结果炸了。这两句拿出来丢到循环外面，需要的时候直接调用就好了

果然问题解决

gchere
关注
  • 1
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 4
    评论
专栏目录
java.lang.IllegalArgumentException: Illegal character in path at index 40解决方案
weixin_43178406的博客
07-17 4万+
本文主要介绍了java.lang.IllegalArgumentException: Illegal character in path at index 40解决方案，希望能对使用Java的同学们有所帮助。 文章目录 1. 问题描述 2. 问题复现 3. 原因分析 4. 解决方案 4.1 方案一 4.2 方案二 5. 修复后
java.lang.IllegalArgumentException: Maximum number of fonts was exceeded
cx1006784951的博客
10-22 542
java.lang.IllegalArgumentException: Maximum number of fonts was exceeded at org.apache.poi.hssf.usermodel.HSSFWorkbook.createFont(HSSFWorkbook.java:1068) ~[poi-3.8.jar:3.8] at com.boku.www.utils.Dow...
使用 com.alibaba:easyexcel 导出excel文件时遇到的问题
最新发布
weixin_46085253的博客
07-17 645
【代码】使用 com.alibaba:easyexcel 导出excel文件时遇到的问题。
Maximum number of fonts was exceeded解决方案
ybcljay的博客
07-18 2650
java.lang.IllegalArgumentException: Maximum number of fonts was exceeded     at org.apache.poi.hssf.usermodel.HSSFWorkbook.createFont(HSSFWorkbook.java:1126)     at com.gskdht.common.util.ExportExcelU...
POI Jar包导出excel问题：maximum number of fonts was exceeded
heartbeaty的专栏
03-12 4976
POI Jar包导出excel问题：maximum number of fonts was exceeded。这个错误是由于导出的数据量变大，多次创建字体样式而导致的；数据量小的时候不会报错。 所以解决办法就是把字体样式的创建、设置放到循环外面，循环调用就可以了。
java excel导出：Maximum number of fonts was exceeded
进击的小白
05-31 635
现象 导出较多数据时出现异常 原因分析 java.lang.IllegalArgumentException: Maximum number of fonts was exceeded at org.apache.poi.hssf.usermodel.HSSFWorkbook.createFont(HSSFWorkbook.java:1163)
java.lang.IllegalArgumentException:Input == null的异常处理
01-08
Caused by: java.lang.IllegalArgumentException: input == null! at javax.imageio.ImageIO.read(ImageIO.java:1388) at com.pleanwar.fiying.FlyingObject.loadImage(FlyingObject.java:52) at ...
如何解决Mybatis--java.lang.IllegalArgumentException: Result Maps collection already contains value for X
08-31
在整合Spring、Struts2和Mybatis的过程中，可能会遇到各种问题，其中之一就是`java.lang.IllegalArgumentException: Result Maps collection already contains value for X`。这个问题通常出现在Mybatis配置文件中，...
java.lang.Exception: java.lang.IllegalArgumentException: firstMovedIndex, lastMo
08-06
标题 "java.lang.Exception: java.lang.IllegalArgumentException: firstMovedIndex, lastMove" 描述了一个Java编程中的异常情况。这个异常通常发生在尝试执行一个不合法的操作时，例如数组或集合操作超出了其边界。...
Maximum最大值
10-10
Maximum最大值
Maximum number of fonts was exceeded解决办法
大造梦家的博客
04-12 1718
触发代码如下: public static void main(String[] args) { HSSFWorkbook sheets = new HSSFWorkbook(); for (int i = 0;i<100000;i++){ HSSFFont font = sheets.createFont(); }...
Maximum number of fonts was exceeded
ClearLoveQ的博客
08-03 292
Excel在导出时出现此错误 原因： HSSFRichTextString richString = new HSSFRichTextString(value); HSSFFont font3 = workbook.createFont(); 这两行代码一定要写到循环外面（或者不使用字体，注释掉），因为excel导出最多只支持32767个font ...
Some text formatting may have changed in this file because the maximum number of fonts was exceeded解决办法
java journey
06-29 5283
google资料: 1. http://www.mrexcel.com/forum/showthread.php?t=354225You are getting the following messageQuote:Originally Posted by dannypon79 some text formatting may h
excel导出 Maximum number of fonts was exceeded异常
chennongsai9031的博客
08-19 216
for(int j = 0;j<data.length;j++){ HSSFCell cell = row.createCell(j); cell.setCellStyle(style2); ...
java.lang.IllegalArgumentException: The maximum length of cell contents (text) is 32,767 characters
shx1133的专栏
03-08 2558
java.lang.IllegalArgumentException: The maximum length of cell contents (text) is 32,767 characters
Exception : Java.lang.IllegalArgumentException : Max length of cell contents(text) is 32,767, charac
m0_50391568的博客
04-29 540
老版本的excel .xls对单元格内容大小有限制，只能容纳32,767字节 解决方法:新建org.apache.poi.ss.SpreadsheetVersion,重新编译 修改后:
java.lang.IllegalArgumentException: Odd number of characters.
12-01
这个异常通常是在使用十六进制字符串转换为字节数组时出现的。如果十六进制字符串的长度是奇数，则会抛出java.lang.IllegalArgumentException: Odd number of characters异常。因为十六进制字符串必须是偶数位，每两个字符表示一个字节。如果字符串长度是奇数，则最后一个字符没有匹配的字符，因此会抛出异常。 以下是一个将十六进制字符串转换为字节数组的示例，如果字符串长度是奇数，则会抛出java.lang.IllegalArgumentException: Odd number of characters异常： ```java public static byte[] hexStringToByteArray(String s) { int len = s.length(); if (len % 2 != 0) { throw new IllegalArgumentException("Odd number of characters."); } byte[] data = new byte[len / 2]; for (int i = 0; i < len; i += 2) { data[i / 2] = (byte) ((Character.digit(s.charAt(i), 16) << 4) + Character.digit(s.charAt(i+1), 16)); } return data; } ```
评论 4
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值