hide all grid but allowed to download excel

[Indra]

Hello, im my application, i created list of history purchase without using sfGrid.

But i want to download my history data with sfgrid excel download capabilities.

how can i download to excel with sfgrid feature, but all the sfgrid are hidden from UI. 

Attachment: Visible_SFGrid_493b0e85.rar

[Jeevakanth Palaniappan]

Hi Indra, 

Greetings from Syncfusion support. 

We have validated your query and we suggest you to export the grid by invoking the ExcelExport method of the grid by using a button click. Please refer the  below code snippet, sample and documentation for your reference. 

<Syncfusion.Blazor.Buttons.SfButton Content="Excel" @onclick="ExcelExport"></Syncfusion.Blazor.Buttons.SfButton> 

 

<SfGrid ID="Grid" @ref="DefaultGrid" DataSource="@Orders" AllowSorting="true" Toolbar="@(new List<string>() { "ExcelExport" })" AllowExcelExport="true" AllowPaging="true"> 

     

</SfGrid> 

 

<style> 

    #Grid { 

    display: none; 

    } 

</style> 

 

@code{ 

    private SfGrid<Order> DefaultGrid; 

 

    public async Task ExcelExport() { 

        await this.DefaultGrid.ExcelExport(); 

    } 

 

} 

Sample - https://www.syncfusion.com/downloads/support/directtrac/general/ze/ServerApp476450755 

Documentation : https://blazor.syncfusion.com/documentation/datagrid/excel-exporting/ 

Regards, 

Jeevakanth SP. 

[Indra]

Thank You! it solved my problem

[Jeevakanth Palaniappan]

Hi Indra, 

We are glad that the provided solution resolved your problem. Please get back to us if you have any other queries. 

Regards, 

Jeevakanth SP.