Calculate row count of a specific column, or pivot table

GemBox.Spreadsheet
1

I’m looking to find the count of rows generated by the pivot table generated.
Row count of a specific column would also suffice.

2

Try using the PivotTable.DataRange, for instance:

pivotTable.PivotCache.Refresh();
pivotTable.Calculate();

var pivotData = pivotTable.DataRange;
for (int r = 0; r < pivotData.Height; r++)
{
    for (int c = 0; c < pivotData.Width; c++)
        Console.Write(pivotData[r, c].Value + " | ");
    Console.WriteLine();
}

I hope this helps.

Regards,
Mario

3

Thank you Mario,

It seems that DataRange is not recgonized as a property of my pivot table.

We are currently using version 49.0.1067 and referencing library GemBox.Spreadsheet.PivotTables

4

This API was added in version 49.0.1202:

1 Like