PivotGridExtension.ExportToXls(PivotGridSettings, Object, Stream, XlsExportOptions) Method

Exports the pivot grid’s data to XLS format, based on the provided settings.

Namespace: DevExpress.Web.Mvc

Assembly: DevExpress.Web.Mvc5.v24.1.dll

NuGet Package: DevExpress.Web.Mvc5

Declaration

C#

public static void ExportToXls(
    PivotGridSettings settings,
    object dataObject,
    Stream stream,
    XlsExportOptions exportOptions
)

VB.NET

Public Shared Sub ExportToXls(
    settings As PivotGridSettings,
    dataObject As Object,
    stream As Stream,
    exportOptions As XlsExportOptions
)

Parameters

Name	Type	Description
settings	PivotGridSettings	A PivotGridSettings object that contains PivotGrid settings.
dataObject	Object	A PivotGrid data source.
stream	Stream	A Stream object to which the data is exported.
exportOptions	XlsExportOptions	An XlsExportOptions object that provides export options.