wpf-devexpress-dot-xpf-dot-grid-dot-tableview-dot-exporttoxlsx-x28-system-dot-string-devexpress-dot-xtraprinting-dot-xlsxexportoptions-x29.md
Using file paths sourced from untrusted input may expose unauthorized files or allow unintended file access. Always validate and normalize all external paths to prevent path manipulation.
Exports a grid to the specified file path in XLSX format, using the specified XLSX-specific options.
Namespace : DevExpress.Xpf.Grid
Assembly : DevExpress.Xpf.Grid.v25.2.dll
NuGet Package : DevExpress.Wpf.Grid.Core
public override void ExportToXlsx(
string filePath,
XlsxExportOptions options
)
Public Overrides Sub ExportToXlsx(
filePath As String,
options As XlsxExportOptions
)
| Name | Type | Description |
|---|---|---|
| filePath | String |
A String which specifies the file name (including the full path) for the created XLSX file.
| | options | XlsxExportOptions |
A XlsxExportOptions object which specifies the XLSX export options to be applied when a grid is exported.
|
To display the Print Preview of the grid, use the DataViewBase.ShowPrintPreview and DataViewBase.ShowPrintPreviewDialog methods. To print the grid, use the DataViewBase.Print or DataViewBase.PrintDirect method.
To learn more, see Printing.
Note
The grid can be previewed, printed and exported only if the DXPrinting Library is available. You should manually add the reference to the DevExpress.Xpf.Printing.v25.2 assembly.
This example shows how to preview, print, and export the GridControl‘s content.
<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>
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");
}
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
The following code snippets (auto-collected from DevExpress Examples) contain references to the ExportToXlsx(String, XlsxExportOptions) method.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
wpf-data-grid-add-page-headers-and-footers-to-exported-data/CS/GridPrint/Window1.xaml.cs#L45
options.CustomizeSheetFooter += options_CustomizeSheetFooter;
view.ExportToXlsx("GridExportExcel.xlsx", options);
Process.Start("GridExportExcel.xlsx");
wpf-data-grid-export-data-to-native-excel-table/CS/WpfApplication80/MainWindow.xaml.cs#L26
options.BeforeExportTable += options_BeforeExportTable;
view.ExportToXlsx("Document.xlsx", options);
Process.Start("Document.xlsx");
wpf-data-grid-add-page-headers-and-footers-to-exported-data/VB/GridPrint/Window1.xaml.vb#L53
AddHandler options.CustomizeSheetFooter, AddressOf options_CustomizeSheetFooter
Me.view.ExportToXlsx("GridExportExcel.xlsx", options)
Call Process.Start("GridExportExcel.xlsx")
wpf-data-grid-export-data-to-native-excel-table/VB/WpfApplication80/MainWindow.xaml.vb#L26
AddHandler options.BeforeExportTable, AddressOf options_BeforeExportTable
Me.view.ExportToXlsx("Document.xlsx", options)
Call Process.Start("Document.xlsx")
See Also