Syncfusion.XlsIO.Base
Example 


RowsPerPage Property

Gets the number of rows per page for this PivotTable that the filter area will occupy. Read-only.
Syntax
'Declaration
 
ReadOnly Property RowsPerPage As Integer
'Usage
 
Dim instance As IPivotTable
Dim value As Integer
 
value = instance.RowsPerPage
int RowsPerPage {get;}
Remarks
To know more about Pivot Tables refer this link.
Example
Following code illustrates how to access the RowsPerPage property of the pivot table.
using Syncfusion.XlsIO;
            
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.Open("Sample.xlsx");
        IWorksheet sheet = workbook.Worksheets[0];
        IWorksheet pivotSheet = workbook.Worksheets[1];
        
        //Gets the number of rows per page for this PivotTable
        int rowsPerPage = pivotSheet.PivotTables[0].RowsPerPage;
        if(rowsPerPage != 0)
        {
            //Your Code Here
        }  
                                           
        workbook.SaveAs("PivotTables.xlsx");
        workbook.Close();
      }
   }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also