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

0
Hi all, I am using below method to create cells in excel file in Java action. And getting the error like The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xls workbook. Please find the attached images. I am using this inside a FOR loop in java. So it is exceeding the limits.  Any suggestions, how can I reduce the creating style inside the method and instead how can I reuse it by creating one time. Thanks in advance. - Venkat
asked
1 answers
1

the limit you are refering to is in Excel. Since you are creating a specific cellstyle for each cell, you'll hit that max quite soon.

Looking at StackOverflow a bit, the following link may help you out:

 

https://stackoverflow.com/questions/42081288/is-there-any-way-to-know-that-the-cellstyle-is-already-present-in-workbookto-re?rq=1

 

Hope this helps!

answered