Skip to main content

PivotGridExtension.OLAPExportToXlsx(PivotGridSettings, String, Stream, XlsxExportOptions) Method

Exports the pivot grid’s data to XLSX format, based on the provided settings. Used only in an OLAP mode.

Namespace: DevExpress.Web.Mvc

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

NuGet Package: DevExpress.Web.Mvc5

Declaration

public static void OLAPExportToXlsx(
    PivotGridSettings settings,
    string connectionString,
    Stream stream,
    XlsxExportOptions exportOptions
)

Parameters

Name Type Description
settings PivotGridSettings

A PivotGridSettings object that contains PivotGrid settings.

connectionString String

A String that specifies the connection string to an OLAP cube.

stream Stream

A Stream object to which the data is exported.

exportOptions XlsxExportOptions

An XlsxExportOptions object that provides export options.

See Also