# datagrid-excel-exporting

> SfDataGrid with buttons to export all or selected rows to Excel, with multi-selection and sorting.

**Framework:** winui  **Component:** DataGrid  **Variant:** excel-exporting

## Get this item

**If you are an agent, fetch the JSON.** Source is inlined, so one request is enough and no tooling is required:

```
GET https://ai.syncfusion.com/r/winui/datagrid-excel-exporting.json
```

**Install Package(s)**

```bash
dotnet add package Syncfusion.Grid.WinUI
```

**Notes**

- Syncfusion release: 2026 Volume 3 (v35.1.37)
- The Syncfusion package is licensed. The composition in this file is source you own and edit. See https://ai.syncfusion.com/licensing.md

## Source files

### src/components/datagrid-excel-exporting/DataGrid.xaml

```xaml
﻿<Page
    x:Class="DataGrid.Samples.ExcelExporting.DataGrid"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:local="using:DataGrid"
    xmlns:dataGrid="using:Syncfusion.UI.Xaml.DataGrid"
    xmlns:grid="using:Syncfusion.UI.Xaml.Grids"
    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
    xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
    mc:Ignorable="d">

    <Grid>
        <Grid.Resources>
            <local:OrderInfoViewModel x:Key="orderInfoViewModel" />
        </Grid.Resources>
        <Grid.RowDefinitions>
            <RowDefinition Height="Auto" />
            <RowDefinition Height="*" />
        </Grid.RowDefinitions>

        <StackPanel Grid.Row="0" Orientation="Horizontal" Margin="10" Spacing="10">
            <Button x:Name="exportDataGrid" Click="ExportDataGrid_Click" Content="Export To Excel" />
            <Button x:Name="exportSelectedItems" Click="ExportSelectedItems_Click" Content="Export Selected Rows" IsEnabled="False" />
        </StackPanel>

        <dataGrid:SfDataGrid x:Name="sfDataGrid"
            Grid.Row="1"
            AllowSorting="True"
            Height="460"
            Width="Auto"
            SelectionMode="Multiple"
            HorizontalAlignment="Stretch"
            VerticalAlignment="Top"
            AutoGenerateColumns="False"
            ColumnWidthMode="AutoLastColumnFill"
            SelectionChanged="SfDataGrid_SelectionChanged"
            DataContext="{StaticResource orderInfoViewModel}"
            ItemsSource="{Binding OrdersDetails}">

            <dataGrid:SfDataGrid.Columns>
                <dataGrid:GridNumericColumn HeaderText="Order ID" MappingName="OrderID" TextAlignment="Right" />
                <dataGrid:GridDateColumn MappingName="OrderDate" HeaderText="Order Date" TextAlignment="Right" />
                <dataGrid:GridTextColumn HeaderText="Customer ID" MappingName="CustomerID" />
                <dataGrid:GridTextColumn HeaderText="Product Name" MappingName="ProductName" />
                <dataGrid:GridTextColumn HeaderText="Ship City" MappingName="ShipCity" />
                <dataGrid:GridTextColumn HeaderText="Ship Country" MappingName="ShipAddress" />
                <dataGrid:GridNumericColumn HeaderText="Quantity" MappingName="Quantity" TextAlignment="Right" />
                <dataGrid:GridNumericColumn HeaderText="Unit Price" MappingName="UnitPrice" DisplayNumberFormat="C2" />
                <dataGrid:GridNumericColumn HeaderText="Discount" MappingName="Discount" DisplayNumberFormat="P" TextAlignment="Right" />
            </dataGrid:SfDataGrid.Columns>
        </dataGrid:SfDataGrid>
    </Grid>
</Page>
```
