GetCellType Method

Gets the cell type for a cell at the specified row and column.

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable Function GetCellType( _
   ByVal row As Integer, _
   ByVal column As Integer _
) As ICellType

'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim value As ICellType
 
value = instance.GetCellType(row, column)

public virtual ICellType GetCellType( 
   int row,
   int column
)

Parameters

row: Row index of the cell
column: Column index of the cell

Return Value

ICellType object containing the cell type

Remarks

Note: If your sheet contains numeric data and you are planning to export the sheet to Excel, for best results place any numeric data in a currency, number, or percent cell in Spread.

Example

This example creates a ButtonCellType in the first cell of the sheet, and returns the type to a list box using the SheetView object.

FarPoint.Web.Spread.SheetView sv=FpSpread1.ActiveSheetView;
sv.Cells[0,0].CellType=new FarPoint.Web.Spread.ButtonCellType();
ListBox1.Items.Add(Convert.ToString(sv.GetCellType(0,0)));

Visual Basic

Dim sv As FarPoint.Web.Spread.SheetView
sv=FpSpread1.ActiveSheetView
sv.Cells(0,0).CellType=NewFarPoint.Web.Spread.ButtonCellType()
ListBox1.Items.Add(Convert.ToString(sv.GetCellType(0,0)))

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

Reference

SheetView Class
SheetView Members
ICellType Interface

User-Task Documentation

Managing Cell Types