Creates a range of cells.
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim instance As New CellRange(row, column, rowCount, columnCount) |
Parameters
- row
- Row index of first cell in the range
- column
- Column index of first cell in the range
- rowCount
- Number of rows in the range
- columnCount
- Number of columns in the range
Example
This example uses a CellRange to create a span in the sheet. The values returned from several of the methods of the range are put in a list box.
| C# | Copy Code |
|---|
FarPoint.Web.Spread.Model.CellRangerange=NewFarPoint.Web.Spread.Model.CellRange(0,0,4,4);
boolb;
FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.RowCount=10;
FpSpread1.ActiveSheetView.AddSpanCell(range.Row,range.Column,range.RowCount,range.ColumnCount);
b=range.Contains(1,1);
ListBox1.Items.Add(Convert.ToString(b)); |
| Visual Basic | Copy Code |
|---|
DimrangeAsNewFarPoint.Web.Spread.Model.CellRange(0,0,4,4)
DimbAsBoolean
FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.RowCount=10
FpSpread1.ActiveSheetView.AddSpanCell(range.Row,range.Column,range.RowCount,range.ColumnCount)
b=range.Contains(1,1)
ListBox1.Items.Add(b) |
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
