Cells Property (SheetView)

Gets the cells in the data area of the sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property Cells As Cells

'Usage
 
Dim instance As SheetView
Dim value As Cells
 
value = instance.Cells

public Cells Cells {get;}

Property Value

Cells object with the cells

Remarks

This property is available at run time only.

This property allows reference to a cell or several cells in the sheet.

Example

This example assigns a SheetView object to the active sheet and creates a Border object. The border is then applied to all the cells in the sheet, and the cells spacing is increased to 5.

FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView;
FarPoint.Web.Spread.Border bord = new FarPoint.Web.Spread.Border(BorderStyle.Dotted, Color.Teal, 2);
int i, j;
for (i = 0; i <= 2; i++)
{
     for (j = 0; j <= 3; j++)
          sv.Cells[i, j].Border = bord;
}
sv.CellSpacing = 5;

Visual Basic

Dim sv As FarPoint.Web.Spread.SheetView
Dim bord As New FarPoint.Web.Spread.Border(BorderStyle.Dotted, Color.Teal, 2)
Dim i, j As Integer
sv = FpSpread1.ActiveSheetView
For i = 0 To 2
      For j = 0 To 3
            sv.Cells(i, j).Border = bord
      Next j
Next i
sv.CellSpacing = 5

Reference

SheetView Class
SheetView Members
Cells Class
Cell Class

User-Task Documentation

Customizing the Appearance of a Cell