Xlwt Code Results In Valueerror: More Than 4094 Xfs (styles)

I am trying to send results of a test to an Excel sheet. In all reality, it is written... poorly. For each piece of data I send to the excel sheet, I attach the style to that com

Solution 1:

Wanted to add this as a comment but I do not have enough reputation. I have been battling with a similar conditional formatting problem and setting the style_compression = 2 as recommended in that other question solved it for me (no, it doesn't compress the data only the styles), however I can see that even with a relatively small spreadsheet there is now a noticeable processing delay.

Otherwise, you have to define all your styles in advance (i.e. outside of the loop) which can be a bit of a hassle if there is only one formatting parameter different here and there.