Slicer.NumberOfColumns
Slicer.NumberOfColumns property
Returns or sets the number of columns in the specified slicer.
public int NumberOfColumns { get; set; }
Examples
using System;
using Aspose.Cells;
using Aspose.Cells.Pivot;
using Aspose.Cells.Slicers;
namespace AsposeCellsExamples
{
public class SlicerPropertyNumberOfColumnsDemo
{
public static void Run()
{
// Create workbook with sample data
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
Cells cells = sheet.Cells;
// Create sample data for pivot table
cells["A1"].Value = "Category";
cells["B1"].Value = "Product";
cells["A2"].Value = "Fruits";
cells["B2"].Value = "Apple";
cells["A3"].Value = "Fruits";
cells["B3"].Value = "Banana";
cells["A4"].Value = "Vegetables";
cells["B4"].Value = "Carrot";
// Create pivot table - store index then get PivotTable object
int pivotIndex = sheet.PivotTables.Add("D1", "A1:B4", "PivotTable");
PivotTable pivotTable = sheet.PivotTables[pivotIndex];
pivotTable.AddFieldToArea(PivotFieldType.Row, "Category");
pivotTable.AddFieldToArea(PivotFieldType.Data, "Product");
pivotTable.RefreshData();
pivotTable.CalculateData();
// Add slicer connected to pivot table
int slicerIndex = sheet.Slicers.Add(pivotTable, "Category", "Slicer1");
Slicer slicer = sheet.Slicers[slicerIndex];
// Configure slicer properties
slicer.Caption = "Product Categories";
slicer.TopPixel = 50;
slicer.LeftPixel = 50;
slicer.HeightPixel = 150;
slicer.WidthPixel = 200;
// Demonstrate NumberOfColumns property
slicer.NumberOfColumns = 2;
// Save the workbook
workbook.Save("SlicerDemo.xlsx");
}
}
}
See Also
- class Slicer
- namespace Aspose.Cells.Slicers
- assembly Aspose.Cells