Export To Excel Never completes

3 posts, 0 answers
  1. Eric Klein
    Eric Klein avatar
    183 posts
    Member since:
    Aug 2009

    Posted 21 Aug 2013 Link to this post

    I have a grid that has the export to excel functionality.  When the grid has a small number of records it works, but in some cases I need to be able to export large number of records.  One instance is 122,103 records. 
    I have the MaxRows set for 1048576, so it should fit on one sheet, but when it hits this line of code.
    I am using ExportToExcelML.
    excelExporter.RunExport(fileName);

    It seems to become unresponsive.  I have let the application run for up to 10 min with the export never being created.

    Also right now I simply change the cursor to a waitcursor during this time, is there anyway to show progress of the export?
  2. Princy
    Princy avatar
    17421 posts
    Member since:
    Mar 2007

    Posted 03 Sep 2013 Link to this post

    Hi Eric,

    Please check the following demo on Export to ExcelML .please have a look at this forum which discusses about showing the progress bar during export.

    Thanks,
    Princy
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Eric Klein
    Eric Klein avatar
    183 posts
    Member since:
    Aug 2009

    Posted 03 Sep 2013 Link to this post

    Thanks for the response, but I have just noticed that this was posted in the asp.net Ajax section, this was meant to be in the winforms.  Is there a solution in winforms for this?
Back to Top