Spread ASP.NET 6.0 Product Documentation
GetCellType Method
See Also  Example Send Feedback
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.SheetViewsv=FpSpread1.ActiveSheetView;
sv.Cells[0,0].CellType=newFarPoint.Web.Spread.ButtonCellType();
ListBox1.Items.Add(Convert.ToString(sv.GetCellType(0,0)));
Visual BasicCopy Code
DimsvAsFarPoint.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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.