Gets the cells in the client area of the active sheet in the Spread component.

Syntax

Visual Basic (Declaration)
Public ReadOnly Property Cells As Cells

Visual Basic (Usage)	Copy Code
Dim instance As FpSpread Dim value As Cells value = instance.Cells

C#
public Cells Cells {get;}

Property Value

Cells object that contains the cells in the data area of the currently selected sheet

Remarks

This property is available at run time only.

Use the Cells, Columns, Rows, and Sheets properties to work with individual cells, columns, rows, or sheets by specifying indices, then setting properties for the specified object.

Example

This example creates a spreadsheet with three sheets, sets the second sheet to be the active sheet, changes the BackColor of the AlternatingRows, and makes the cells in the first column button cells.

C#	Copy Code
FpSpread1.Sheets.Count=3; FpSpread1.ActiveSheetViewIndex=1; FpSpread1.ActiveSheetView.AlternatingRows[0].BackColor=Color.Yellow; FpSpread1.ActiveSheetView.AlternatingRows[1].BackColor=Color.YellowGreen; FpSpread1.ActiveSheetView.Cells[0,0].CellType=newFarPoint.Web.Spread.ButtonCellType(); FpSpread1.ActiveSheetView.Cells[1,0].CellType=newFarPoint.Web.Spread.ButtonCellType(); FpSpread1.ActiveSheetView.Cells[2,0].CellType=newFarPoint.Web.Spread.ButtonCellType();

Copy Code

FpSpread1.Sheets.Count=3;
FpSpread1.ActiveSheetViewIndex=1;
FpSpread1.ActiveSheetView.AlternatingRows[0].BackColor=Color.Yellow;
FpSpread1.ActiveSheetView.AlternatingRows[1].BackColor=Color.YellowGreen;
FpSpread1.ActiveSheetView.Cells[0,0].CellType=newFarPoint.Web.Spread.ButtonCellType();
FpSpread1.ActiveSheetView.Cells[1,0].CellType=newFarPoint.Web.Spread.ButtonCellType();
FpSpread1.ActiveSheetView.Cells[2,0].CellType=newFarPoint.Web.Spread.ButtonCellType();

Visual Basic	Copy Code
FpSpread1.Sheets.Count=3 FpSpread1.ActiveSheetViewIndex=1 FpSpread1.ActiveSheetView.AlternatingRows(0).BackColor=Color.Yellow FpSpread1.ActiveSheetView.AlternatingRows(1).BackColor=Color.YellowGreen FpSpread1.ActiveSheetView.Cells(0,0).CellType=NewFarPoint.Web.Spread.ButtonCellType() FpSpread1.ActiveSheetView.Cells(1,0).CellType=NewFarPoint.Web.Spread.ButtonCellType() FpSpread1.ActiveSheetView.Cells(2,0).CellType=NewFarPoint.Web.Spread.ButtonCellType()

Visual Basic

Copy Code

FpSpread1.Sheets.Count=3
FpSpread1.ActiveSheetViewIndex=1
FpSpread1.ActiveSheetView.AlternatingRows(0).BackColor=Color.Yellow
FpSpread1.ActiveSheetView.AlternatingRows(1).BackColor=Color.YellowGreen
FpSpread1.ActiveSheetView.Cells(0,0).CellType=NewFarPoint.Web.Spread.ButtonCellType()
FpSpread1.ActiveSheetView.Cells(1,0).CellType=NewFarPoint.Web.Spread.ButtonCellType()
FpSpread1.ActiveSheetView.Cells(2,0).CellType=NewFarPoint.Web.Spread.ButtonCellType()

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Syntax

Property Value

Remarks

Example

Requirements

See Also

Reference

User-Task Documentation

Spread for ASP.NET 7.0 Product Documentation
Cells Property
See Also Example Support Options