Spread for ASP.NET 9.0 Product Documentation
GetCellType Method
Example 


Row index of the cell
Column index of the cell
Gets the cell type for a cell at the specified row and column.
Syntax
'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)));
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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

SheetView Class
SheetView Members
ICellType Interface

User-Task Documentation

Managing Cell Types

 

 


Copyright © GrapeCity, inc. All rights reserved.