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 98, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0. SpreadsheetGear for .NET 2006 requires the Microsoft .NET Framework 2.0.

See Also