Skip to main content

PivotGridControl.SavePivotGridToFile(String, Boolean) Method

Saves the Pivot Grid Control’s data and full layout to the specified file, and allows the data to be compressed.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v24.1.dll

NuGet Package: DevExpress.Win.PivotGrid


public void SavePivotGridToFile(
    string path,
    bool compress


Name Type Description
path String

A string that specifies the path to the file in which the control’s data and layout will be saved.

compress Boolean

true to compress the output file; otherwise, false.


You can disable data compression if this affects data saving/loading performance. For data compression, this method uses the Deflate algorithm (a combination of the LZ77 algorithm and Huffman coding). See the DeflateStream topic in MSDN for more details.

For information on using the SavePivotGridToFile method, see another method overload.


In OLAP and Server Mode, you cannot save pivot grid data to a file / stream.


Saving PivotGrid’s data to a file or stream is not supported for Server Mode and OLAP data sources.

See Also