Spread WPF Documentation
GetArray(Int32,Int32,Int32,Int32,Boolean) Method


Row index of the cell from which to read into the array
Column index of the cell from which to read into the array
Number of rows in the array
Number of columns in the array
If true, return formulas; otherwise, return values.
Gets an object array from a specified range of cells.
Syntax
'Declaration
 
Public Overloads Function GetArray( _
   ByVal row As System.Integer, _
   ByVal column As System.Integer, _
   ByVal rowCount As System.Integer, _
   ByVal columnCount As System.Integer, _
   ByVal formula As System.Boolean _
) As System.Object(,)
'Usage
 
Dim instance As Worksheet
Dim row As System.Integer
Dim column As System.Integer
Dim rowCount As System.Integer
Dim columnCount As System.Integer
Dim formula As System.Boolean
Dim value() As System.Object
 
value = instance.GetArray(row, column, rowCount, columnCount, formula)
public System.object[,] GetArray( 
   System.int row,
   System.int column,
   System.int rowCount,
   System.int columnCount,
   System.bool formula
)

Parameters

row
Row index of the cell from which to read into the array
column
Column index of the cell from which to read into the array
rowCount
Number of rows in the array
columnCount
Number of columns in the array
formula
If true, return formulas; otherwise, return values.
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

Worksheet Class
Worksheet Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.