SpreadsheetGear The Performance Spreadsheet Component Company 
Count Property
See Also  Example
SpreadsheetGear Namespace > IRange Interface : Count Property
Returns the number of cells, rows, or columns in a range.

Syntax

C# 
virtual int Count {get;}

Example

C#Copy Code
int numberOfCells = worksheet.Cells["A1:B3"].Count; // 6 cells 
int numberOfRows = worksheet.Cells["A1:B3"].Rows.Count; // 3 rows 
int numberOfCols = worksheet.Cells["A1:B3"].Columns.Count; // 2 columns 
    
Visual BasicCopy Code
Dim numberOfCells As Integer = worksheet.Cells("A1:B3").Count ' 6 cells
Dim numberOfRows As Integer = worksheet.Cells("A1:B3").Rows.Count ' 3 rows
Dim numberOfCols As Integer = worksheet.Cells("A1:B3").Columns.Count ' 2 columns

Requirements

Platforms: Windows Vista, Windows XP, Windows Server 2008, Windows Server 2003, Windows 2000, Windows Me and Windows 98, including 32 bit and 64 bit editions where applicable. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0 (works with .NET 3.x). SpreadsheetGear for .NET 2007 requires the Microsoft .NET Framework 2.0 (works with .NET 3.x).

See Also