Spread Silverlight Documentation
SetCellFormula Method


The zero based sheet index used to locate the IExcelWorkbook instance
The zero based cell row index
The zero based cell column index
The formula used to set the value
Set formula for a specified cell.
Syntax
'Declaration
 
Function SetCellFormula( _
   ByVal sheet As System.Short, _
   ByVal row As System.Integer, _
   ByVal column As System.Integer, _
   ByVal cellFormula As IExcelFormula _
) As System.Boolean
'Usage
 
Dim instance As IExcelReader
Dim sheet As System.Short
Dim row As System.Integer
Dim column As System.Integer
Dim cellFormula As IExcelFormula
Dim value As System.Boolean
 
value = instance.SetCellFormula(sheet, row, column, cellFormula)
System.bool SetCellFormula( 
   System.short sheet,
   System.int row,
   System.int column,
   IExcelFormula cellFormula
)

Parameters

sheet
The zero based sheet index used to locate the IExcelWorkbook instance
row
The zero based cell row index
column
The zero based cell column index
cellFormula
The formula used to set the value

Return Value

true If the cell is in a valid cell in the specified worksheet, otherwise, false
Exceptions
ExceptionDescription
System.ArgumentNullExceptionthrows if the formula is null or empty.
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

IExcelReader Interface
IExcelReader Members

 

 


Copyright © GrapeCity, inc. All rights reserved.