Spread Windows Forms 11.0 Product Documentation
SetValue Method (SheetView)


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : SetValue Method
Sets the value for the specified cell on this sheet.
Sets the value for the cell of the specified row and column on this sheet.
Overload List
OverloadDescription
SetValue(Int32,Int32,Object)Sets the value for the specified cell on this sheet.  
SetValue(Int32,Int32,Boolean)Sets the value for the specified cell on this sheet.  
SetValue(Int32,Int32,DateTime)Sets the value for the specified cell on this sheet.  
SetValue(Int32,Int32,Double)Sets the value for the specified cell on this sheet.  
SetValue(Int32,Int32,Int32)Sets the value for the specified cell on this sheet.  
SetValue(Int32,Int32,Char)Sets the value for the specified cell on this sheet.  
SetValue(Int32,Int32,SByte)Sets the value for the specified cell on this sheet.  
SetValue(Int32,Int32,Byte)Sets the value for the specified cell on this sheet.  
SetValue(Int32,Int32,Int16)Sets the value for the specified cell on this sheet.  
SetValue(Int32,Int32,UInt16)Sets the value for the specified cell on this sheet.  
SetValue(Int32,Int32,UInt32)Sets the value for the specified cell on this sheet.  
SetValue(Int32,Int32,Int64)Sets the value for the specified cell on this sheet.  
SetValue(Int32,Int32,UInt64)Sets the value for the specified cell on this sheet.  
SetValue(Int32,Int32,Single)Sets the value for the specified cell on this sheet.  
SetValue(Int32,Int32,Decimal)Sets the value for the specified cell on this sheet.  
SetValue(Int32,Int32,String)Sets the value for the specified cell on this sheet.  
SetValue(Int32,Int32,Object,Boolean)Sets the value for the specified cell on this sheet.  
Remarks

Besides using this method, you can get or set the value in a cell using various properties of the sheet (SheetView object) or properties of the cell (Cell object). For more information, see Handling Data Using Sheet Methods and Handling Data Using Cell Properties.

Remember that the data may be displayed differently in a cell depending on the cell type. For more information, see Understanding Cell Type Effects on Displaying Data.

An InvalidArgumentException is possible with this method if the value is invalid.

See Also

Reference

SheetView Class
SheetView Members
SetArray Method
SetClip Method
SetClipValue Method
SetValue Method
Cell.Text Property
Cell.Value Property
SetText Method

User-Task Documentation

Placing and Retrieving Data
Handling Data Using Sheet Methods

 

 

Copyright © GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page