Syncfusion.XlsIO.Base
Example 


ColumnsPerPage Property

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

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also