@page "/data-grid-excel-export"
@rendermode InteractiveServer
@using Syncfusion.Blazor.Grids

@inject ILogger<DataGridExcelExport> Logger

<SfGrid ID="Grid" DataSource="SalesOrders" Toolbar="@(new List<string>() { "ExcelExport" })" AllowExcelExport="true" AllowFiltering="true" @ref="Grid">
    <GridEvents TValue="SalesOrder" OnToolbarClick="ToolbarClick" OnActionFailure="ActionFailure" />
    <GridColumns>
        <GridColumn Field="@nameof(SalesOrder.OrderDate)" />
    </GridColumns>
</SfGrid>

@code {
    SfGrid<SalesOrder> Grid { get; set; } = null!;

    IEnumerable<SalesOrder> SalesOrders = [
        new SalesOrder { OrderDate = new DateOnly(2024, 1, 1) },
        new SalesOrder { OrderDate = new DateOnly(2024, 1, 2) },
        new SalesOrder { OrderDate = new DateOnly(2024, 1, 3) }
    ];

    async Task ToolbarClick(Syncfusion.Blazor.Navigations.ClickEventArgs args)
    {
        if (args.Item.Id == "Grid_excelexport")
        {
            try
            {
                await Grid.ExportToExcelAsync();
            }
            catch (Exception exception)
            {
                Logger.LogError(exception, "ToolbarClick");
            }
        }
    }

    void ActionFailure(FailureEventArgs args)
    {
        Logger.LogError(args.Error, "ActionFailure");
    }

    class SalesOrder
    {
        public DateOnly OrderDate { get; set; }
    }
}