Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IPivotTable Interface : PivotEngineValues Property

PivotEngineValues Property

Gets or sets the Syncfusion.XlsIO.Implementation.PivotAnalysis.PivotEngine of the pivot table.
Syntax
'Declaration
 
Property PivotEngineValues As PivotEngine
'Usage
 
Dim instance As IPivotTable
Dim value As PivotEngine
 
instance.PivotEngineValues = value
 
value = instance.PivotEngineValues
PivotEngine PivotEngineValues {get; set;}
Remarks
This property is not supported in UWP, Xamarin and ASP.NET Core platforms. To know more about Pivot Tables refer this link.
Example
Following code snippet illustrates how to use PivotEngineValues property.
using Syncfusion.XlsIO;
using Syncfusion.XlsIO.Implementation.PivotAnalysis;
            
class Example
{
   static void Main()
   {
      using (ExcelEngine excelEngine = new ExcelEngine())
      {
        //Create a worksheet.        
        IApplication application = excelEngine.Excel;
        application.DefaultVersion = ExcelVersion.Excel2013;
        IWorkbook workbook = application.Workbooks.Create(2);
        IWorksheet sheet = workbook.Worksheets[0];
        IWorksheet pivotSheet = workbook.Worksheets[1];
        sheet.Range["A1"].Text = "Student ID";
        sheet.Range["B1"].Text = "Student Name";
        sheet.Range["C1"].Text = "Mark(Out of 100)";
        sheet.Range["A1:C1"].AutofitColumns();
        sheet.Range["A2"].Number = 1;
        sheet.Range["A3"].Number = 2;
        sheet.Range["A4"].Number = 3;
        sheet.Range["A5"].Number = 4;
        sheet.Range["A6"].Number = 5;
        sheet.Range["B2"].Text = "Andrew";
        sheet.Range["B3"].Text = "Marson";
        sheet.Range["B4"].Text = "Jack";
        sheet.Range["B5"].Text = "Sam";
        sheet.Range["B6"].Text = "Breto";
        sheet.Range["C2"].Number = 77;
        sheet.Range["C3"].Number = 45;
        sheet.Range["C4"].Number = 92;
        sheet.Range["C5"].Number = 39;
        sheet.Range["C6"].Number = 55;
        IPivotCache cache = workbook.PivotCaches.Add(sheet["A1:C6"]);
        IPivotTable pivotTable = pivotSheet.PivotTables.Add("PivotTable1", pivotSheet["A1"], cache);         
        pivotTable.Fields[0].Axis = PivotAxisTypes.Column;
        pivotTable.Fields[1].Axis = PivotAxisTypes.Row;
        IPivotField datafield = pivotTable.Fields[2];
        pivotTable.DataFields.Add(datafield, "Sum of Marks", PivotSubtotalTypes.Sum);
        pivotTable.BuiltInStyle = PivotBuiltInStyles.PivotStyleMedium20;
        pivotTable.Layout();
        
        //Gets the pivot engine of the pivot table
        PivotEngine pivotEngine = pivotTable.PivotEngineValues;
        if(pivotEngine != null)
        {
            //Your Code Here
        }
        
        workbook.SaveAs("PivotTables.xlsx");
        workbook.Close();
      }
   }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also