PivotGridControl.ExportToXls(String) Method

Exports the Pivot Grid Control’s data to the specified file as XLS.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v19.1.dll

Declaration

C#

public void ExportToXls(
    string filePath
)

VB.NET

Public Sub ExportToXls(
    filePath As String
)

Parameters

Name	Type	Description
filePath	String	A String which specifies the full path (including the file name and extension) to where the XLS file will be created.

Remarks

Numeric values of data fields will be exported as numbers, not as text. To export data field values as text, use another ExportToXls method overload with the useNativeFormat parameter and set this parameter to false.

The ExportToXls method indirectly calls the PrintingSystemBase.ExportToXls method of the XtraPrinting Library. If this library is not available, the method does nothing. For details on the ExportToXls method, see the PrintingSystemBase.ExportToXls topic.

For general information on exporting data, see Exporting.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference 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.

VB.NET

how-to-avoid-production-of-unnecessary-column-and-merging-of-cells-in-excel-export-e2346/VB/WindowsApplication53/Form1.vb#L58

Try
    pivotGridControl1.ExportToXls(fileName)
    System.Diagnostics.Process.Start(fileName)