Spread for ASP.NET 7.0 Product Documentation
GetCellType Method
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : GetCellType Method


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

Glossary Item Box

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

Syntax

Visual Basic (Declaration) 
Public Overridable Function GetCellType( _
   ByVal row As Integer, _
   ByVal column As Integer _
) As ICellType
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim value As ICellType
 
value = instance.GetCellType(row, column)
C# 
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.
C#Copy Code
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 BasicCopy Code
Dim sv As 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)))

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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.