Skip to content
OFFICE · COMPLETE

DataGridSpreadsheetButton

Let users take the data in a grid to a spreadsheet file with one click.

A button that takes the rows of a data grid, after filtering and sorting, into a spreadsheet file.

Why it helps

  • One-click export
  • Respects filters and sort
  • Visible columns

Where it fits

  • Reports
  • Exports
  • Sharing

Example

<DataGrid @ref="_grid" Items="SampleData.People" PageSize="6" Striped ShowToolbar Label="People">
    <ToolbarContent>
        <DataGridSpreadsheetButton TItem="Person" Grid="_grid" FileName="people" SheetName="People" />
        <DataGridPdfButton TItem="Person" Grid="_grid" FileName="people" Title="People" />
    </ToolbarContent>
    <Columns>
        <DataGridColumn Title="Name" Value="@(p => p.Name)" />
        <DataGridColumn Title="Department" Value="@(p => p.Department)" />
        <DataGridColumn Title="Age" Value="@(p => p.Age)" Align="TextAlign.Right" Width="6rem" />
    </Columns>
</DataGrid>

@code {
    private DataGrid<Person>? _grid;
}

A short fragment. Add @using RayCraft.Blazor.Components to your page and use an interactive render mode.

Part of RayCraft Complete.

All controls ยท Documentation