PivotGridControl.SavePivotGridToFile(String) Method
Saves the PivotGridControl’s data and layout to the specified file.
Namespace: DevExpress.Xpf.PivotGrid
Assembly: DevExpress.Xpf.PivotGrid.v19.1.dll
Declaration
Parameters
Name | Type | Description |
---|---|---|
path | String | A String value that specifies the path to the file in which the control’s data and layout are saved. |
Remarks
To restore the layout, use the PivotGridControl.RestorePivotGridFromFile method.
To learn more, see Save and Restore Layout.
Note
Saving PivotGrid’s data to a file or stream is not supported for Server Mode and OLAP data sources.
Example
This example shows how to save (or restore) the PivotGridControl‘s data and layout to a file. To correctly restore fields if the pivot grid’s PivotGridControl.Fields collection is empty, the PivotSerializationOptions.RemoveOldFields property should be set to false.
Note
A complete sample project is available at https://github.com/DevExpress-Examples/how-to-work-with-the-dxpivotgrid-control-offline-e2124.
Imports Microsoft.VisualBasic
Imports System.Data
Imports System.Data.OleDb
Imports System.Windows
Imports DevExpress.Xpf.PivotGrid
Imports HowToBindToMDB.NwindDataSetTableAdapters
Imports System.IO
Imports DevExpress.Xpf.Core
Namespace HowToBindToMDB
''' <summary>
''' Interaction logic for MainWindow.xaml
''' </summary>
Partial Public Class MainWindow
Inherits Window
Private salesPersonDataTable As New NwindDataSet.SalesPersonDataTable()
Private salesPersonDataAdapter As New SalesPersonTableAdapter()
Public Sub New()
InitializeComponent()
pivotGridControl1.DataSource = salesPersonDataTable
End Sub
Private Sub Window_Loaded(ByVal sender As Object, ByVal e As RoutedEventArgs)
salesPersonDataAdapter.Fill(salesPersonDataTable)
End Sub
Private Sub button1_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
pivotGridControl1.SavePivotGridToFile("pivot.dat", True)
pivotGridControl1.DataSource = Nothing
pivotGridControl1.Fields.Clear()
End Sub
Private Sub button2_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
If (Not File.Exists("pivot.dat")) Then
DXMessageBox.Show("You should save the PivotGrid into a file first")
Return
End If
pivotGridControl1.RestorePivotGridFromFile("pivot.dat")
End Sub
End Class
End Namespace