Class PivotEngineSerialization

Serializes the pivot engine.

Inheritance

System.Object

PivotEngineSerialization

Namespace: Syncfusion.XlsIO.Implementation.XmlSerialization.PivotTables

Assembly: Syncfusion.XlsIO.Portable.dll

Syntax

public class PivotEngineSerialization : Object

Constructors

PivotEngineSerialization()

Declaration

public PivotEngineSerialization()

Methods

AutoFitPivotTable(IRange, IPivotTable)

AutoFits the pivot table.

Declaration

public void AutoFitPivotTable(IRange range, IPivotTable pivotTable)

Parameters

Type	Name	Description
IRange	range	Range in which the pivot table is located.
IPivotTable	pivotTable	The pivot table which is to be autofitted.

PopulatePivotEngine(IWorksheet, PivotTableImpl)

Populates the specifed pivot table.

Declaration

public PivotEngine PopulatePivotEngine(IWorksheet sheet, PivotTableImpl pivotTable)

Parameters

Type	Name	Description
IWorksheet	sheet	Source worksheet for the pivot table.
PivotTableImpl	pivotTable	The pivot table which is to be populated.

Returns

Type	Description
PivotEngine

RenderPivotTable(PivotEngine, IWorksheet, PivotTableImpl)

Renders the pivot table values.

Declaration

public void RenderPivotTable(PivotEngine pivotEngine, IWorksheet pivotSheet, PivotTableImpl pivotTable)

Parameters

Type	Name	Description
PivotEngine	pivotEngine	PivotEngine object.
IWorksheet	pivotSheet	Sheet in which the pivot table is present.
PivotTableImpl	pivotTable	The pivot table which is to be rendered.

ReplaceDelimiter(Object, String, String)

Replaces the delimiter in grand total.

Declaration

public object ReplaceDelimiter(object replacableValue, string delimiter, string newValue)

Parameters

Type	Name	Description
System.Object	replacableValue	The target object in which replacement is to be done.
System.String	delimiter	The old delimiter.
System.String	newValue

Returns

Type	Description
System.Object	The target object after the replacement.