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. 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