Class PivotEngineSerialization
Serializes the pivot engine.
Inheritance
System.Object
PivotEngineSerialization
Namespace: Syncfusion.XlsIO.Implementation.XmlSerialization.PivotTables
Assembly: Syncfusion.XlsIO.NET.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 |
---|
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. |