PivotGridControl.ExportToXls(Stream) Method

Exports the Pivot Grid Control’s data as XLS and sends it to the specified stream.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v24.1.dll

NuGet Package: DevExpress.Win.PivotGrid

Declaration

C#

public void ExportToXls(
    Stream stream
)

VB.NET

Public Sub ExportToXls(
    stream As Stream
)

Parameters

Name	Type	Description
stream	Stream	A Stream object to which the created document is exported.

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.