GrapeCity.Documents.Excel.IPivotTable.PivotRowAxis

PivotRowAxis Property

PivotRowAxis

Gets the IPivotAxis object that represents the entire row axis of the PivotTable report.

Use this axis to work with the row-side structure of a PivotTable, such as the pivot lines displayed down the left side of the report.

Declaration

IPivotAxis PivotRowAxis { get; }

ReadOnly Property PivotRowAxis As IPivotAxis

Examples

worksheet.Range["A1:C5"].Value = new object[,] {
    {"Category", "Region", "Amount"},
    {"Beverages", "East", 120},
    {"Beverages", "West", 80},
    {"Snacks", "East", 95},
    {"Snacks", "West", 110}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:C5"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["E1"], "SalesPivot");
pivotTable.PivotFields["Category"].Orientation = PivotFieldOrientation.RowField;
IPivotAxis rowAxis = pivotTable.PivotRowAxis;
IPivotLines lines = rowAxis.PivotLines;