SpreadsheetGear 2010
Count Property
See Also  Example Send Feedback
SpreadsheetGear Namespace > IRange Interface : Count Property

Deprecated - use CellCount, RowCount or ColumnCount.

Syntax

Visual Basic (Declaration) 
<ObsoleteAttribute()>
ReadOnly Property Count As Integer
C# 
[ObsoleteAttribute()]
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

Remarks

NOTE: This property will throw an exception if the count exceeds Int32.MaxValue.

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

Copyright © 2003-2010 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.