java.lang.IllegalStateException: The maximum number of cell styles was exceeded. You can define up t

最新推荐文章于 2024-04-26 23:58:00 发布
最新推荐文章于 2024-04-26 23:58:00 发布
阅读量2.8k 收藏 1
点赞数 1
分类专栏： java--bug
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/wu920604/article/details/52838454
版权

报错信息

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) ~[poi-3.8.jar:3.8]
	at com.founder.manage.controller.FocChannelController.buildMainbody(FocChannelController.java:134) ~[classes/:na]
	at com.founder.manage.controller.FocChannelController.uploadExcelByPoi(FocChannelController.java:98) ~[classes/:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_79]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_79]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_79]
	at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_79]
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221) ~[spring-web-4.2.6.RELEASE.jar:4.2.6.RELEASE]
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136) ~[spring-web-4.2.6.RELEASE.jar:4.2.6.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110) ~[spring-webmvc-4.2.6.RELEASE.jar:4.2.6.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:832) ~[spring-webmvc-4.2.6.RELEASE.jar:4.2.6.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:743) ~[spring-webmvc-4.2.6.RELEASE.jar:4.2.6.RELEASE]
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) ~[spring-webmvc-4.2.6.RELEASE.jar:4.2.6.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961) ~[spring-webmvc-4.2.6.RELEASE.jar:4.2.6.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895) ~[spring-webmvc-4.2.6.RELEASE.jar:4.2.6.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967) ~[spring-webmvc-4.2.6.RELEASE.jar:4.2.6.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:858) ~[spring-webmvc-4.2.6.RELEASE.jar:4.2.6.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:622) ~[tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843) ~[spring-webmvc-4.2.6.RELEASE.jar:4.2.6.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) ~[tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) ~[tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) ~[tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) ~[tomcat-embed-websocket-8.0.33.jar:8.0.33]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) ~[tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) ~[tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) ~[spring-web-4.2.6.RELEASE.jar:4.2.6.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.2.6.RELEASE.jar:4.2.6.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) ~[tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) ~[tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:87) ~[spring-web-4.2.6.RELEASE.jar:4.2.6.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.2.6.RELEASE.jar:4.2.6.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) ~[tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) ~[tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77) ~[spring-web-4.2.6.RELEASE.jar:4.2.6.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.2.6.RELEASE.jar:4.2.6.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) ~[tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) ~[tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121) ~[spring-web-4.2.6.RELEASE.jar:4.2.6.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.2.6.RELEASE.jar:4.2.6.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) ~[tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) ~[tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) ~[tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) [tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) [tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) [tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) [tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) [tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522) [tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095) [tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672) [tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1502) [tomcat-embed-core-8.0.33.jar:8.0.33]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1458) [tomcat-embed-core-8.0.33.jar:8.0.33]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_79]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_79]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-8.0.33.jar:8.0.33]
	at java.lang.Thread.run(Thread.java:745) [na:1.7.0_79]

原因及解决方案：poi 导出excel时。导出的数据不是很大时，则不会有问题，但是在数据很多或者比较多的时候，就会报上面的错误，它是由于cell styles太多create造成的，所以通常可以将cellStyle设置放到循环外面。


                

        

        

    




    

      

        

            

              
                
                  开着拖拉机的梦想家
                
              
            

            

                关注
              
            

        

        

          
    
            
  • 
              
                
                
                
                
                    1
                
              
              
    点赞
    
            
    • 
            
  • 
              
                
                
                
              
              
    踩
    
            
    • 
            
  • 
              
                
                
                
                
                    1
                
              
              
    
                
    
                  
                    收藏
                  
                
    
              
    
              
    
                
    
                  觉得还不错?
                  
                    一键收藏
                  
                 
                
    
              
    
            
    • 
          
  • 
            
    
              
              
            
    
              
              
              
                    0
              
            
            
    评论
    
          
    • 
          
  • 
          
    • 
          
  • 
            
              
            
              
    
            
              
                
            
    
          
    • 
        

      

      

            

                专栏目录
          










                



	

		

			

				
					
java.lang.IllegalStateException: The maximum number of cell styles was exceeded.

				
			

			

				

					游海东的技术专栏
				

				

					11-12
					
					6468
					
				

			

		

		

			
				
1、错误描述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.createCellStyl

			
		

	



                

              
                



	

		

			

				
					
POI The maximum number of Cell Styles was exceeded.You can define up to x style in a x Workbook问题解决

				
			

			

				

					旭东怪的博客
				

				

					09-03
					
					3235
					
				

			

		

		

			
				
问题描述：

java.lang.IllegalStateException: The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook

问题分析：

1、使用EasyExcel创建单元格样式时，有64000个单元格创建了单元格样式，导致报错。


     /**
     * 导出（设置单元格样式）
     *
     * @param response


			
		

	



                


  
              

                


	

		

			

				
					
Caused by: java.lang.IllegalStateException: The maximum number of cell styles was exceeded. You can

				
			

			

				

					qq_36876035的博客
				

				

					07-07
					
					930
					
				

			

		

		

			
				
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.a

			
		

	





	

		

			

				
					
亲测有效，已解决java.lang.IllegalStateException异常的正确解决方法，嘿嘿嘿

					
最新发布

				
			

			

				

					PythonAigc的博客
				

				

					04-26
					
					3136
					
				

			

		

		

			
				
出现 IllegalStateException 的原因可能有很多，但通常涉及以下几种情况：

对象状态不正确：例如，你可能尝试在一个没有初始化的对象上调用方法。
线程安全问题：多线程环境下，如果没有正确的同步，对象的状态可能会被破坏。
生命周期问题：在对象的生命周期中的某个不合适的时刻执行了某个操作。

			
		

	



		

			
		



	

		

			

				
					
解决样式多问题  You can define up to 4000 styles 包括poi全部jar

				
			

			

				

					03-18
				

			

		

		

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

			
		

	





	

		

			

				
					
java excel 字体大小_java操作Excel的poi的字体设置

				
			

			

				

					weixin_29800175的博客
				

				

					02-23
					
					3049
					
				

			

		

		

			
				
package com.java.poi;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.ss.usermodel.*;import java.io.FileOutputStream;/*** 字体设置* @author nidegui* @create 2019-06-17 11:30*/public...

			
		

	





	

		

			

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

				
			

			

				

					by_lucky_seven的博客
				

				

					02-01
					
					4241
					
				

			

		

		

			
				
Caused by: java.lang.IllegalStateException: The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xls workbook
最近在写excel导出功能是，要求按照不同的成品进行sheet分页。需要按照将第一个模板复制多份
需要循环多

			
		

	





	

		

			

				
					
java.lang.IllegalStateException

				
			

			

				

					菜小菜吃菜的博客
				

				

					05-22
					
					849
					
				

			

		

		

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


excel poi中，导出的数据不是很大时，则不会有问题，而数据很多或者比较多时，

就会报以下的错误，是由于cell 

			
		

	





	

		

			

				
					
Java异常之—-Caused by: java.lang.IllegalStateException: Method has too many Body parameters

				
			

			

				

					01-20
				

			

		

		

			
				
异常：Caused by: java.lang.IllegalStateException: Method has too many Body parameters  Caused by: java.lang.IllegalStateException: Method has too many Body parameters: public abstract ...

			
		

	





	

		

			

				
					
java.lang.IllegalStateException: Cannot call sendError() after the response has 

				
			

			

				

					04-21
				

			

		

		

			
				
在Java的Web开发中，`java.lang.IllegalStateException: Cannot call sendError() after the response has been committed` 是一个常见的错误，通常发生在尝试在HTTP响应已经发送到客户端之后调用`sendError()`方法...

			
		

	





	

		

			

				
					
Android异常 java.lang.IllegalStateException解决方法

				
			

			

				

					01-04
				

			

		

		

			
				
1. java.lang.IllegalStateException: No wrapped connection.  2.java.lang.IllegalStateException: Adapter is detached. 原因： 1.单线程一次执行一个请求可以正常执行，如果使用多线程，同时执行多个请求时就会...

			
		

	





	

		

			

				
					
You can define up to 4000 styles in a .xls workbook is a wrong excepiton

				
			

			

				

					03-18
				

			

		

		

			
				
The maximum number of cell styles was exceeded.  You can define up to 4000 styles in a .xls workbook is a wrong excepiton  将抛异常的方法去掉，是程序继续执行，生成excel  。本来想免费，但是苦于没积分所以要了5分 见谅 。实在没积分的话可以给我发邮件，给你送一个，呵呵

			
		

	





	

		

			

				
					
java.lang.IllegalStateException: getOutputStream() has already解决办法

				
			

			

				

					09-17
				

			

		

		

			
				
纠结了半天的 java.lang.IllegalStateException: getOutputStream() has already。这个问题困扰了半天,在网上查阅了大量资料 出这个错误一般就是下面2个.....

			
		

	





	

		

			

				
					
The maximum number of cell styles was exceeded. You can define up to 4000 styles

				
			

			

				

					Hermosa_Young的专栏
				

				

					03-28
					
					962
					
				

			

		

		

			
				

在用POI导出Excel表格时，报如下错误：
 
Caused by: java.lang.IllegalStateException: The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xls workbook
 
原因：style创建次数太多。
 
改进方...

			
		

	





	

		

			

				
					
POI 操作Excel的单元格样式超过64000的异常问题解决

				
			

			

				

					飞一站的博客
				

				

					03-10
					
					4279
					
				

			

		

		

			
				
解决POI 操作Excel文件是自定义样式的64000个异常的问题。

			
		

	





	

		

			

				
					
c#使用Npoi 提示 Excel导出报错 The maximum number of cell styles was exceeded. You can define up to 4000

				
			

			

				

					sd6275832ght的博客
				

				

					10-15
					
					2695
					
				

			

		

		

			
				
在使用NPOI 导出EXCEL的时候  提示
The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xls workbook
出现此问题 原因如下：
private static void SetFontSize(IFont font,IWorkbook wk,string co...

			
		

	





	

		

			

				
					
java.lang.IllegalStateException: The maximum numbe

				
			

			

				

					weixin_33851429的博客
				

				

					08-22
					
					324
					
				

			

		

		

			
				
2019独角兽企业重金招聘Python工程师标准>>>   
                                        
         ...

			
		

	





	

		

			

				
					
Caused by: java.lang.IllegalStateException: java.lang.IllegalStateException: Logback configuration error detected: 

				
			

			

				

					08-26
				

			

		

		

			
				
Caused by: java.lang.IllegalStateException: Logback configuration error detected的问题是由于Logback配置错误引起的。根据引用和引用的信息，可能的解决办法如下：
1. 检查Logback的配置文件，确保配置文件的语法和结构正确。可以尝试重新编写或更新Logback配置文件。
2. 检查Logback依赖是否正确添加到项目的依赖管理中。可以使用Maven或Gradle等构建工具来管理项目的依赖。
3. 检查Logback的日志输出路径和文件权限，确保日志文件可以被正常写入。
4. 检查Logback的日志输出级别，确保日志级别的设置与期望的输出一致。
5. 检查Logback的相关组件和库是否与项目的其他组件和库版本兼容，避免引起冲突或不兼容问题。
6. 如果以上方法都无法解决问题，可以尝试搜索相关错误信息和解决方案，参考引用提供的Android Caused by: java.lang.ClassNotFoundException解决办法的相关资料，看是否能找到类似的解决方法来解决Logback配置错误的问题。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
-  *1* *3* [关于Caused by: java.lang.IllegalStateException:问题解决办法！](https://blog.csdn.net/m0_52255061/article/details/115248503)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
-  *2* [Android Caused by: java.lang.ClassNotFoundException解决办法](https://download.csdn.net/download/weixin_38703295/12784351)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]

			
		

	



              




          




        



    





    



      

      

        
      

      





	

		评论	
	

	
	




  

    

      添加红包
      
    

    

      

        
        

          
          
        

        
请填写红包祝福语或标题

      

      

        
        

          
          个
        

        
红包个数最小为10个

      

      

        
        

          
          元
        

        
红包金额最低5元

      

      

        
        

          当前余额3.43元
          前往充值 >
        

      

      

        

          需支付：10.00元
        

        
        
      

    

  





  

    
    
  

  

    
    
  








  

    

      

        

          

            
            
成就一亿技术人!

          

          

        

        

          

          

            领取后你会自动成为博主和红包主的粉丝
            规则
          

        

      

      

        

          

            
              
            
            

              
hope_wisdom
 发出的红包
            

          

        

        

          

          

          

        

      

    

    

  



      
      

      
实付元

      
使用余额支付

      

        

          

            
            点击重新获取
          

        

        
扫码支付

      

      

        
          
            
          
          
        
      

      

        
        钱包余额
          0
          

            
            

              

                
抵扣说明：

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

              

            

          

      

      余额充值