: The maximum number of cell styles was exceeded.

时间:2025-04-23 08:33:30

1、错误描述

: The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xls workbook
	at (:1215)
	at (:121)
	at (:358)
	at .invoke0(Native Method)
	at (:57)
	at (:43)
	at (:606)
	at (:317)
	at (:190)
	at (:157)
	at (:52)
	at (:179)
	at (:92)
	at (:179)
	at (:207)
	at .$(Unknown Source)
	at (:130)
	at .invoke0(Native Method)
	at (:57)
	at (:43)
	at (:606)
	at (:215)
	at (:132)
	at (:104)
	at (:749)
	at (:689)
	at (:83)
	at (:938)
	at (:870)
	at (:961)
	at (:852)
	at (:620)
	at (:837)
	at (:727)
	at (:303)
	at (:208)
	at (:52)
	at (:241)
	at (:208)
	at (:32)
	at (:241)
	at (:208)
	at (:64)
	at (:241)
	at (:208)
	at (:88)
	at (:107)
	at (:241)
	at (:208)
	at (:61)
	at (:108)
	at (:137)
	at (:125)
	at (:66)
	at (:449)
	at $(:365)
	at (:90)
	at (:83)
	at (:383)
	at (:362)
	at (:125)
	at (:344)
	at (:261)
	at (:241)
	at (:208)
	at (:220)
	at (:122)
	at (:501)
	at (:171)
	at (:103)
	at (:950)
	at (:116)
	at (:408)
	at .http11.(:1070)
	at $(:611)
	at $(:316)
	at (:1145)
	at $(:615)
	at $(:61)
	at (:745)

2、错误原因

     由于导出到Excel文件,超过了Excel中的sheet页显示的最大记录数,导致出现异常报错


3、解决办法

(1)导出Excel分sheet页

(2)可以将导出格式换成txt,但是这个是改变用户需求的,需要经过客户同意