Skip to main content

PivotGridExtension.OLAPExportToXls(PivotGridSettings, String, String, Boolean) Method

Exports the pivot grid’s data to XLS 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 ActionResult OLAPExportToXls(
    PivotGridSettings settings,
    string connectionString,
    string fileName,
    bool saveAsFile
)

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.

fileName String

A String value that specifies the target file name.

saveAsFile Boolean

true to display the File Download dialog; false to display the file with exported data within a page.

Returns

Type Description
ActionResult

A ActionResult encapsulating the result of the PivotGrid data export operation.

See Also