Class GridExcelExport

GridExcelExport exports the Pivot data to Excel with the applied style

Inheritance
System.Object
GridExcelExport
Implements
System.IDisposable
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: Syncfusion.Windows.Grid.Olap.Converter
Assembly: Syncfusion.OlapGridConverter.WPF.dll
Syntax
public class GridExcelExport : IDisposable

Constructors

GridExcelExport(PivotEngine, ExportingGridStyleInfo, GridLayout, String, Boolean)

Initializes a new instance of the GridExcelExport class.

Declaration
public GridExcelExport(PivotEngine DrillResult, ExportingGridStyleInfo styleinfo, GridLayout layout, string Ext, bool ItemSource)
Parameters
Type Name Description
PivotEngine DrillResult

The drill result.
ExportingGridStyleInfo styleinfo

The styleinfo.
GridLayout layout

The layout.
System.String Ext

The extension.
System.Boolean ItemSource

if set to true [item source].

GridExcelExport(PivotEngine, ExportingGridStyleInfo, GridLayout, String, Boolean, FreezableCollection<OlapGridDataConditionalFormat>)

Initializes a new instance of the GridExcelExport class.

Declaration
public GridExcelExport(PivotEngine DrillResult, ExportingGridStyleInfo styleinfo, GridLayout layout, string Ext, bool ItemSource, FreezableCollection<OlapGridDataConditionalFormat> ConditionalFormat)
Parameters
Type Name Description
PivotEngine DrillResult

The drill result.
ExportingGridStyleInfo styleinfo

The styleinfo.
GridLayout layout

The layout.
System.String Ext

The extension.
System.Boolean ItemSource

if set to true [item source].
System.Windows.FreezableCollection<OlapGridDataConditionalFormat> ConditionalFormat

The ConditionalFormats.

GridExcelExport(PivotEngine, Object, GridLayout, String, Boolean)

Initializes a new instance of the GridExcelExport class.

Declaration
public GridExcelExport(PivotEngine drillResult, object styleInfo, GridLayout layout, string Ext, bool ItemSource)
Parameters
Type Name Description
PivotEngine drillResult

The drill result.
System.Object styleInfo

The styleinfo.
GridLayout layout

The layout.
System.String Ext

The extension.
System.Boolean ItemSource

if set to true [item source].

GridExcelExport(OlapDataManager, ExportingGridStyleInfo, GridLayout, String, Boolean, FreezableCollection<OlapGridDataConditionalFormat>, Boolean, Boolean)

Initializes a new instance of the GridExcelExport class.

Declaration
public GridExcelExport(OlapDataManager dataManager, ExportingGridStyleInfo styleInfo, GridLayout gridLayout, string ext, bool itemsSource, FreezableCollection<OlapGridDataConditionalFormat> conditionalFormats, bool allowCompleteDataExport, bool ignoreStyles)
Parameters
Type Name Description
OlapDataManager dataManager

The olap data manager.
ExportingGridStyleInfo styleInfo

The styleinfo.
GridLayout gridLayout

The layout.
System.String ext

The extension.
System.Boolean itemsSource

if set to true [item source].
System.Windows.FreezableCollection<OlapGridDataConditionalFormat> conditionalFormats

The ConditionalFormats.
System.Boolean allowCompleteDataExport

Boolean value indicates to export complete data from cell set.
System.Boolean ignoreStyles

Boolean value indicates to export data without styles.

Methods

Dispose()

This method is used to clear all the instances.

Declaration
public void Dispose()

Export(String)

Exports the specified file name.

Declaration
public void Export(string FileName)
Parameters
Type Name Description
System.String FileName

Name of the file.

SaveAs(String)

To save the Workbook with Exported Data

Declaration
public void SaveAs(string Filename)
Parameters
Type Name Description
System.String Filename

The filename.

Events

Exporting

Occurs when the olap grid is being exported to an excel file.

Declaration
public event ExportingEventHandler Exporting
Event Type
Type
ExportingEventHandler

Implements

System.IDisposable