Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Chandrashekhar
20
Cancel functionality for Export of High data grid into Excel (UltraGridExcelExporter)
posted

Hi

We are using Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter for exporting UltraGrid data into Excel Sheet.

For high volume data (Near about 1,000,000 Records) it takes considerable time to Export.

User requires cancel to export functionality if this scenario occurs.

Could you please provide your inputs, how to implement the cancel option with paging of this data for Export.

(Progress bar with Cancel option, Cancle the export will save the records already exported)

 Same case With PDF Export as well

  • 469350
    Suggested Answer
    Offline posted

    You could handle the InitializeRow event of the UltraGridExcelExporter. The event args for this event has a property called TerminateExport. Setting this to true will stop the export.

    However, the firing of InitializeRow is pretty quick, and it's probably not the major portion of the export process. And once the InitializeRow has fired for all of the rows and the excel file is being written, there's no way to stop the exporting at that point.