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()
Dim worksheet As SpreadsheetGear.IWorksheet = SpreadsheetGear.Factory.GetWorkbook().Worksheets("Sheet1")
System.Console.WriteLine(worksheet.Cells("B3:C5").Count)
System.Console.WriteLine(worksheet.Cells("B3:C5").Columns.Count)
System.Console.WriteLine(worksheet.Cells("B3:C5").Columns.Cells.Count)
End Sub
End Class
|
Requirements
Platforms: Windows 2000, Windows XP, Windows Vista, Windows Server 2003 and Windows Server 2008. SpreadsheetGear 2009 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.
See Also