ExportToExcelML performance

[Ed M]

Hello,

I recently noticed that the ExportToExcelML peformance is much faster if the application that calls the RunExport method is minimized.

I am calling RunExport on a background thread, so I thought perhaps it was just my code. So, I performed some tests on the Telerik Demo application, and found the same results. For 1000 records, the export takes about 40 seconds if I don't minimize the application. If minimized, it only takes about 3 seconds. This is in agreement with the performance of my own application.

Can you please verify that this is indeed the case? If so, is this a bug that will be fixed in a future release?

Thank you.

Ed M.

edit: The demo I am comparing to is ExcelML with Events. I used the same pattern to perform the export in a background thread. If I call the RunExport method in the UI thread for my application, the export takes less than 3 seconds for 1000 records. I am using the Winforms Q1-2011-SP1 release.

[Ed M.]

Support ticket submitted.

[Martin Vasilev]

Hello Ed M.,

Thank you for writing.

It is true that there is performance decrease when exporting with visual settings. In addition, we do not support running export in a background process. Although such scenario works, the UI thread is still used to traverse the grid and this explains why if you minimize the form it finishes faster. Unfortunately, there is not a way to overcome this limitation except exporting without visual settings.

We are looking into the issue and have plans to improve the performance. However, I am unable to give you an exact time frame for this feature yet.

Let me know if you have any other questions.

Regards,
Martin Vasilev
the Telerik team

[Ed M]

Thank you for your reply, Martin.

Performance is very good when ExportVisualSettings is set to false. For now, my users will have to live with it.

Would you consider supporting an asynchronous export in the future, allowing progress updates and cancelling? Right now, I can use the ExcelCellFormatting event to update progress, but it can be rather slow. I cannot, however, cancel the export. I can do a thread.abort, but the export still continues in the background.

-Ed M.

[Martin Vasilev]

Hello Ed M,

Yes, we are aware of the performance issues when using export in background thread. We have plans to improve this and provide good progress visualization in one of the future releases. However, this task is related to functionality at the base level of our grid and such a change would require some implementation and testing time. That is why I still cannot give you an exact time frame, and indeed using export without visual settings is the way to have good performance with the current version.

Do not hesitate to contact me again if you have any other questions.

Greetings,
Martin Vasilev
the Telerik team

[Joaquim]

Hello,

 

I have grid with 11 000 record, When I can export to excel this export delay 11 minutes.

I have this code

 string fileName = saveFileDialog1.FileName;
                    ExportToExcelML exporter = new ExportToExcelML(this.radGridView1);
                    exporter.HiddenRowOption = HiddenOption.DoNotExport;                                        
                    exporter.ExportVisualSettings = false;                    
                    //exporter.RadGridViewToExport = this.radGridView1;
                    exporter.RunExport(fileName); 

 how can I optimize this process?

 

I have 2014.3.1021.20 version.

Best regards

Joaquim

[Todor]

Hello Joaquim,

Thank you for writing.

I could not reproduce this problem, so could you please send us a sample project so that we can investigate exactly against your scenario.

Since the forums do not allow attaching projects you could upload it to some free server like Dropbox for example (just make sure you upload the project without the Telerik assemblies). If you prefer, you could also open a support ticket, attach the project and continue our communication there. 

Looking forward to hearing from you.

Regards,
Todor Vyagov
Telerik