The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
Hello! I am trying to increase the performance when I create an Excel document. It has many (hundreds) conditional formatting formulas, creates 30 worksheets (password-protected) and applies one of 9 styles to data. A team member suggested to find a way to supress calculation when creating and applying the conditional formatting formulas, but I saw in another post that the file creation is binary and that the calculation will be actually performed when Excel opens the file. Is this still correct with XlsIO? Can you provide us with some of your insight on possible tips and tricks to increase the performance? Thanks in advance!
I ran a performance analyzer on the application and 70% of the cycle time was taken by the Save() method.
ADAdministrator Syncfusion Team June 1, 2006 08:39 PM UTC
Hi Elsa,
1) Yes, you are correct in assuming that there is no calculation performed in XlsIO and that all calculation is done only when MS Excel opens the file.
2) Would it be possible to send us the file that is generated after applying all the conditional formats by opening a Direc-Trac incident. We could possibly reproduce the issue by just opening and resaving the file using XlsIO. Also, please provide the time taken currently. We are also currently working on optimizing the performance of XlsIO so we will try our best to improve performance as much as possible.
Best regards,
Stephen.
>I ran a performance analyzer on the application and 70% of the cycle time was taken by the Save() method.
JKJuin Kar replied to Elsa April 8, 2018 03:42 PM UTC
Hello! I am trying to increase the performance when I create an Excel document. It has many (hundreds) conditional formatting formulas, creates 30 worksheets (password-protected) and applies one of 9 styles to data. A team member suggested to find a way to supress calculation when creating and applying the conditional formatting formulas, but I saw in another post that the file creation is binary and that the calculation will be actually performed when Excel opens the file. Is this still correct with XlsIO? Can you provide us with some of your insight on possible tips and tricks to increase the performance? Thanks in advance!
Thank you..
AVAbirami Varadharajan Syncfusion Team April 9, 2018 09:00 AM UTC
Hi Juin,
Please refer to below documentation to know more on improving performance using XlsIO.