SpreadsheetGear 2010
CellCount Property
See Also Example Send Feedback

SpreadsheetGear Namespace > IRange Interface : CellCount Property

Visual Basic (Declaration)
C#

Returns the number of cells represented by this range.

Syntax

Visual Basic (Declaration)
ReadOnly Property CellCount As Long

C#
long CellCount {get;}

Example

C#	Copy Code
long numberOfCells = worksheet.Cells["A1:XFD1048576"].CellCount; // 17,179,869,184 cells

Visual Basic	Copy Code
Dim numberOfCells As Long = worksheet.Cells("A1:XFD1048576").CellCount ' 17179869184 cells

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

Reference

IRange Interface
IRange Members
RowCount Property
ColumnCount Property
AreaCount Property
Count Property

See our live ASP.NET Excel Reporting, Excel Charting, Dashboards from Charts and Ranges, Excel Calculation and Excel to DataGrid Samples.

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.