Spread WPF Documentation
SetArrayFormula Method (IExcelReader)


The zero based sheet index used to locate the IExcelWorksheet instance
The zero based inclusive top left cell row index
The zero based inclusive bottom right cell row index
The zero based inclusive top left cell column index
The zero based inclusive top left cell column index
The array formula for these cell
Set array formula to a range of cells
Syntax
'Declaration
 
Sub SetArrayFormula( _
   ByVal sheet As System.Integer, _
   ByVal rowFirst As System.Integer, _
   ByVal rowLast As System.Integer, _
   ByVal columnFirst As System.Short, _
   ByVal columnLast As System.Short, _
   ByVal arrayFormula As IExcelFormula _
) 
'Usage
 
Dim instance As IExcelReader
Dim sheet As System.Integer
Dim rowFirst As System.Integer
Dim rowLast As System.Integer
Dim columnFirst As System.Short
Dim columnLast As System.Short
Dim arrayFormula As IExcelFormula
 
instance.SetArrayFormula(sheet, rowFirst, rowLast, columnFirst, columnLast, arrayFormula)
void SetArrayFormula( 
   System.int sheet,
   System.int rowFirst,
   System.int rowLast,
   System.short columnFirst,
   System.short columnLast,
   IExcelFormula arrayFormula
)

Parameters

sheet
The zero based sheet index used to locate the IExcelWorksheet instance
rowFirst
The zero based inclusive top left cell row index
rowLast
The zero based inclusive bottom right cell row index
columnFirst
The zero based inclusive top left cell column index
columnLast
The zero based inclusive top left cell column index
arrayFormula
The array formula for these cell
Exceptions
ExceptionDescription
System.ArgumentNullExceptionthrows when 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 (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

See Also

Reference

IExcelReader Interface
IExcelReader Members

 

 


Copyright © GrapeCity, inc. All rights reserved.