GetCellType Method

In This Topic

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)))

Reference

SheetView Class
SheetView Members
ICellType Interface

User-Task Documentation

Managing Cell Types

Product Support Forum | Print this page