GridControl.ExportToXls(String) Method

Exports the data the GridControl.DefaultView (GridControl.MainView or the currently maximized detail View) displays to a file in XLS format.

Namespace: DevExpress.XtraGrid

Assembly: DevExpress.XtraGrid.v18.2.dll

Declaration

C#

public void ExportToXls(
    string filePath
)

VB.NET

Public Sub ExportToXls(
    filePath As String
)

Parameters

Name	Type	Description
filePath	String	A string that specifies the full path to the file to which the View’s data will be exported.

Remarks

See Export to XLS and XLSX Formats to learn more.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ExportToXls(String) 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.

C#

how-to-customize-the-resulting-file-during-printing-exporting-gridcontrol-e2722/CS/WindowsApplication1/GridExportHelper.cs#L91

{
    _GridControl.ExportToXls(fileName);
}

how-to-export-the-gridcontrol-data-if-the-gridcontrol-isnt-the-form-control-e516/CS/WindowsApplication1/Form1.cs#L39

grid.ExportToXls("1.xls");
Process.Start("1.xls");

how-to-find-out-why-the-gridcontrols-exportto-method-does-not-work-e2756/CS/Form1.cs#L71

string fileName = String.Format("{0}GridControl.xls", targetFileName);
gridControl1.ExportToXls(fileName);
return File.Exists(fileName);

how-to-print-group-summary-values-under-corresponding-columns-e2084/CS/Q250602/Form1.cs#L21

private void OnExportToXlsButtonClick(object sender, EventArgs e) {
    orderDetailsGrid.ExportToXls(@"..\..\order_details.xls");
    //orderDetailsGrid.ExportToHtml(@"..\..\order_details.html");

how-to-show-cells-values-over-an-image-and-be-able-to-export-the-cells-content-to-excel-file-e2043/CS/WindowsApplication1/Form1.cs#L73

button1.Enabled = false;
gridControl1.ExportToXls(XLSfileName);
Process.Start(XLSfileName);

VB.NET

how-to-customize-the-resulting-file-during-printing-exporting-gridcontrol-e2722/VB/GridExportHelper.vb#L74

Private Sub DoExport(ByVal fileName As String)
    _GridControl.ExportToXls(fileName)
End Sub

how-to-export-the-gridcontrol-data-if-the-gridcontrol-isnt-the-form-control-e516/VB/WindowsApplication1/Form1.vb#L37

grid.ExportToXls("1.xls")
Process.Start("1.xls")

how-to-find-out-why-the-gridcontrols-exportto-method-does-not-work-e2756/VB/Form1.vb#L62

Dim fileName As String = String.Format("{0}GridControl.xls", targetFileName)
gridControl1.ExportToXls(fileName)
Return File.Exists(fileName)

how-to-print-group-summary-values-under-corresponding-columns-e2084/VB/Q250602/Form1.vb#L23

Private Sub OnExportToXlsButtonClick(ByVal sender As Object, ByVal e As EventArgs) Handles simpleButton2.Click
    orderDetailsGrid.ExportToXls("..\..\order_details.xls")
    'orderDetailsGrid.ExportToHtml(@"..\..\order_details.html");

how-to-show-cells-values-over-an-image-and-be-able-to-export-the-cells-content-to-excel-file-e2043/VB/WindowsApplication1/Form1.vb#L65

button1.Enabled = False
gridControl1.ExportToXls(XLSfileName)
Process.Start(XLSfileName)