Returns the cells represented by this instance of
IRange.
Syntax
| Visual Basic (Declaration) | |
|---|
ReadOnly Property Cells As IRange |
Example
| C# |  Copy Code |
|---|
class Program
{
static void Main()
{
// Create a worksheet.
SpreadsheetGear.IWorksheet worksheet =
SpreadsheetGear.Factory.GetWorkbook().Worksheets["Sheet1"];
// Writes "6" (two columns by three rows).
System.Console.WriteLine(worksheet.Cells["B3:C5"].Count);
// Writes "2" (two columns).
System.Console.WriteLine(worksheet.Cells["B3:C5"].Columns.Count);
// Writes "6" (back to two columns by three rows).
System.Console.WriteLine(worksheet.Cells["B3:C5"].Columns.Cells.Count);
}
} |
| Visual Basic | Copy Code |
|---|
Class Program
Shared Sub Main()
' Create a worksheet.
Dim worksheet As SpreadsheetGear.IWorksheet = SpreadsheetGear.Factory.GetWorkbook().Worksheets("Sheet1")
' Writes "6" (two columns by three rows).
System.Console.WriteLine(worksheet.Cells("B3:C5").Count)
' Writes "2" (two columns).
System.Console.WriteLine(worksheet.Cells("B3:C5").Columns.Count)
' Writes "6" (back to two columns by three rows).
System.Console.WriteLine(worksheet.Cells("B3:C5").Columns.Cells.Count)
End Sub 'Main
End Class 'Program |
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
