Cancel excel, PDF, csv export or print

[SZL]

Hello,

I have a Blazor grid with lot of rows. Sometimes the export operation or print takes a long time.

I would like insert a Cancel button if the user dont want wait more. 

This is possible (for example CancellationToken or similar)?

Thank you for help!

BR, László

[Rachel Gomez]

Steps To Save Or Export Each Sheet As CSV/PDF File In Excel-

As you know, Microsoft Excel can save current worksheet as an individual .csv file or PDF file. Therefore, you can save or export every sheet as .csv file or PDF file one by one manually.

1. Switch to the sheet that you will save or export as an individual .csv file, and click File (or Office button) > Save As.

2. In the opening dialog box, specify the destination folder that you will save the .csv file into, click the Save as type box and select CSV (Comma delimited) (*.csv) or PDF (*.pdf) from the drop down list, and click the Save button.

3. There will be two warning dialog boxes coming out successively. Please click OK > Yes.

Note: If you save active worksheet as PDF file, these dialog boxes won't pop up. Just go ahead to next step.

4. Repeat above step 1-3 to save other sheets as individual .csv files one by one.

Batch Save Or Export Each Sheet As CSV File With VBA

If there are a number of sheets that you want to save or export as .csv files, the first method will be quite time-consuming and tedious. This VBA can simplify working and make it easy to save or export each sheet as .csv file.

1. Press Alt + F11 keys simultaneously to open the Microsoft Visual Basic for Application window.

2. Click Insert > Module, and then paste following VBA code into the new module window.

3. Click the Run button or press F5 key to run this VBA.

4. In the opening Browse dialog box, specify the destination folder that you will save all .csv files into, and click the OK button.

Regards,

Rachel Gomez

[SZL]

Thank you for fast reply!

Sorry my description was not too accurate.

So I would like Cancel these toolbar operations (in DataGrid / Exporting / Default Exporting page):

https://blazor.syncfusion.com/demos/datagrid/exporting?theme=bootstrap5

For example:

- Load 50000 rows to grid.

- Click on Excel Export button in Toolbar.

- Export processing in background -> I would like to Cancel this if the user press a Cancel button (in a popup dialog for example).

I think there are an another problem, looks like the 

    await this.PrimaryGrid.ExportToExcelAsync();

blocks the UI thread while running, so the user cannot click on Cancel button.

Thank you!

BR, László

[Renjith Singh Rajendran]

Hi SZL, 

 

Greetings from Syncfusion support. 

 

We are checking the feasibility of achieving this scenario from our side. We will update you further details within two business days.  

 

Until then we appreciate your patience. 

 

Regards, 

Renjith R

[SZL]

Hi,

Thank you, it is not so urgent! :)

Have a nice day!

BR, SZL

[Renjith Singh Rajendran]

Hi SZL, 

 

We have further analyzed this requirement. We would like to inform you that, we don’t have option to cancel the ongoing export action. It is a not feasible requirement from our side. 

 

Please get back to us if you need further assistance. 

 

Regards, 

Renjith R