I have Performance Issues with the Excel spreadprocessing export. I just migrated an Excel export that used until now the libraries "Component One". The export takes now 30 seconds for 7221 rows and 88 columns, against 5 seconds before. Here is the code:
The code that takes the most time is:
- Lines 42 - 77: Fill the sheet with data: 12 seconds
- Line 122: AutoFitWidth(): 6 seconds --> (It's important, cannot be removed)
- Line 22: formatProvider.Export(excBook, fsOutput): 11 seconds --> That's very long !!!
Can you check my code and tell me if there are any improvements, please? So i can unfortunately not use the libraries.
Thanks in advance