ExportToExcelML performance

7 posts, 0 answers
  1. Ed M
    Ed M avatar
    1 posts
    Member since:
    Jun 2011

    Posted 28 Jun 2011 Link to this post

    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.
  2. Ed M.
    Ed M. avatar
    1 posts
    Member since:
    Jun 2011

    Posted 30 Jun 2011 Link to this post

    Support ticket submitted.
  3. UI for WinForms is Visual Studio 2017 Ready
  4. Martin Vasilev
    Admin
    Martin Vasilev avatar
    1061 posts

    Posted 01 Jul 2011 Link to this post

    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
    Registration for Q2 2011 What’s New Webinar Week is now open. Mark your calendar for the week starting July 18th and book your seat for a walk through all the exciting stuff we ship with the new release!
  5. Ed M
    Ed M avatar
    1 posts
    Member since:
    Jun 2011

    Posted 01 Jul 2011 Link to this post

    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.
  6. Martin Vasilev
    Admin
    Martin Vasilev avatar
    1061 posts

    Posted 06 Jul 2011 Link to this post

    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

    Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!

  7. Joaquim
    Joaquim avatar
    1 posts
    Member since:
    Jul 2015

    Posted 10 Jul 2015 in reply to Martin Vasilev Link to this post

    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

  8. Todor Vyagov
    Admin
    Todor Vyagov avatar
    31 posts

    Posted 13 Jul 2015 Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top
UI for WinForms is Visual Studio 2017 Ready