GrapeCity.Documents.Excel.IPivotAxis

IPivotAxis Interface

Represents the axis for a PivotTable report.

An IPivotAxis represents either the row axis or the column axis of a IPivotTable. Use it to access the IPivotLines attached to that axis.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface IPivotAxis

Public Interface IPivotAxis

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Category", "Amount"},
    {"Fruit", 100},
    {"Fruit", 200},
    {"Vegetables", 150}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B4"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["D1"], "SalesPivot");
IPivotAxis pivotAxis = pivotTable.PivotRowAxis;
IPivotLines pivotLines = pivotAxis.PivotLines;

Properties

Name	Description
PivotLines	Gets the IPivotLines collection attached to this pivot axis. The returned collection contains all pivot lines on the current axis. For a row axis, each pivot line represents a row in the pivot table axis area. For a column axis, each pivot line represents a column in the pivot table axis area.

Name

Description

PivotLines

Gets the IPivotLines collection attached to this pivot axis.

The returned collection contains all pivot lines on the current axis. For a row axis, each pivot line represents a row in the pivot table axis area. For a column axis, each pivot line represents a column in the pivot table axis area.