GrapeCity.Documents.Excel.IPivotTable.RowRange

RowRange Property

RowRange

Gets the range that includes the row area in the PivotTable report.

The returned range represents the cells used by row fields and row items in the current PivotTable layout.

Declaration

IRange RowRange { get; }

ReadOnly Property RowRange As IRange

Examples

worksheet.Range["A1:B5"].Value = new object[,] {
    {"Category", "Amount"},
    {"Fruit", 120},
    {"Fruit", 80},
    {"Vegetables", 95},
    {"Vegetables", 60}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B5"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["D1"], "SalesPivot");
pivotTable.PivotFields["Category"].Orientation = PivotFieldOrientation.RowField;
IRange rowRange = pivotTable.RowRange;