Back to Devexpress

How to: Print and Export the GridControl

wpf-6967-controls-and-libraries-printing-exporting-examples-how-to-print-and-export-the-dxgrid-control.md

latest2.1 KB
Original Source

How to: Print and Export the GridControl

  • Jun 08, 2022

This example shows how to preview, print, and export the GridControl‘s content.

View Example

xaml
<Grid>
    <Grid.RowDefinitions>
        <RowDefinition Height="*"/>
        <RowDefinition Height="Auto"/>
    </Grid.RowDefinitions>
    <dxg:GridControl x:Name="grid" AutoGenerateColumns="AddNew">
        <dxg:GridControl.View>
            <dxg:TableView x:Name="view" AutoWidth="True"/>
        </dxg:GridControl.View>
    </dxg:GridControl>
    <WrapPanel Grid.Row="1" Orientation="Horizontal">
        <Button Click="PreviewGrid" Content="Show Print Preview"/>
        <Button Click="ExportToXls" Content="Export to Excel"/>
        <Button Click="ExportToCsv" Content="Export to CSV"/>
        <Button Click="ExportToPng" Content="Export to an image"/>
    </WrapPanel>
</Grid>
cs
void PreviewGrid(object sender, RoutedEventArgs e) {
    view.ShowPrintPreviewDialog(this);
}
void ExportToXls(object sender, RoutedEventArgs e) {
    view.ExportToXlsx(@"d:\grid_export.xlsx");
}
void ExportToCsv(object sender, RoutedEventArgs e) {
    view.ExportToCsv(@"d:\grid_export.csv");
}
void ExportToPng(object sender, RoutedEventArgs e) {
    view.ExportToImage(@"d:\grid_export.png");
}
vb
Private Sub PreviewGrid(ByVal sender As Object, ByVal e As RoutedEventArgs)
    Me.view.ShowPrintPreviewDialog(Me)
End Sub

Private Sub ExportToXls(ByVal sender As Object, ByVal e As RoutedEventArgs)
    Me.view.ExportToXlsx("d:\grid_export.xlsx")
End Sub

Private Sub ExportToCsv(ByVal sender As Object, ByVal e As RoutedEventArgs)
    Me.view.ExportToCsv("d:\grid_export.csv")
End Sub

Private Sub ExportToPng(ByVal sender As Object, ByVal e As RoutedEventArgs)
    Me.view.ExportToImage("d:\grid_export.png")
End Sub