ExcelSetArrayFormula Method

In This Topic

ARRAY - Excel Biff Record

Syntax

Visual Basic
C#

'Declaration
 
Function ExcelSetArrayFormula( _
   ByVal sheet As Integer, _
   ByVal rowFirst As Integer, _
   ByVal rowLast As Integer, _
   ByVal colFirst As Short, _
   ByVal colLast As Short, _
   ByVal formula() As Byte, _
   ByVal extra() As Byte _
) As Boolean

'Usage
 
Dim instance As IExcelBiffRead
Dim sheet As Integer
Dim rowFirst As Integer
Dim rowLast As Integer
Dim colFirst As Short
Dim colLast As Short
Dim formula() As Byte
Dim extra() As Byte
Dim value As Boolean
 
value = instance.ExcelSetArrayFormula(sheet, rowFirst, rowLast, colFirst, colLast, formula, extra)

bool ExcelSetArrayFormula( 
   int sheet,
   int rowFirst,
   int rowLast,
   short colFirst,
   short colLast,
   byte[] formula,
   byte[] extra
)

Parameters

sheet: Sheet index
rowFirst
rowLast
colFirst
colLast
formula
extra

Reference

IExcelBiffRead Interface
IExcelBiffRead Members

Product Support Forum | Print this page