Loading state on export

[Sven Boris Bornemann]

Hi,

is it possible to show some kind of loading state on using the export functions (ExcelExport, CsvExport) on the DataGrid?

Because on big datasets it took a lot of time and the user get no feedback and think the export doesn't work!

Best regards

Sven

[Monisha Saravanan]

Hi Sven, 

Yes, it is possible. We suggest you to invoke ShowSpinnerAsync and HideSpinnerAsync methods of the Grid. So that spinner will be shown during exporting. Kindly refer the below code snippet and sample for your reference 

 

<SfGrid @ref="Grid" DataSource="@Orders" Height="700" AllowPdfExport="true" AllowExcelExport="true" Toolbar="@(new List<string>() { "ExcelExport","CsvExport","PdfExport" })"> 

    <GridEvents ExportComplete="ExportCompleteHandler" OnToolbarClick="ToolbarClickHandler" TValue="Order"></GridEvents> 

    ... 

</SfGrid> 

 

@code{ 

 

    public async Task ToolbarClickHandler(Syncfusion.Blazor.Navigations.ClickEventArgs args) 

    { 

        if (args.Item.Text == "Excel Export") 

        { 

            await Grid.ShowSpinnerAsync(); 

            await this.Grid.ExcelExport(); 

             

        } 

         

    } 

 

    public async void ExportCompleteHandler(object args) 

    { 

        await Grid.HideSpinnerAsync(); 

    } 

} 

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/DataGrid-1596538409.zip 

Refer the below API documentation for your reference 

https://help.syncfusion.com/cr/blazor/Syncfusion.Blazor.Grids.SfGrid-1.html#Syncfusion_Blazor_Grids_SfGrid_1_HideSpinnerAsync 

https://help.syncfusion.com/cr/blazor/Syncfusion.Blazor.Grids.SfGrid-1.html#Syncfusion_Blazor_Grids_SfGrid_1_ShowSpinnerAsync 

Kindly revert us if you have further queries. 

Regards, 

Monisha S 

[Sven Boris Bornemann]

Hi,

it worked.

Thank you and best regards

Sven

[Vignesh Natarajan]

Hi Sven,  

Thanks for the update.  

We are glad to hear that you have resolved your query using our solution.  

Please get back to us if you have further queries. 

Regards, 

Vignesh Natarajan