GetArray(Int32,Int32,Int32,Int32) Method

Visual Basic
C#

'Declaration
 
Public Overloads Function GetArray( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer _
) As Object(,)

'Usage
 
Dim instance As Worksheet
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim value() As Object
 
value = instance.GetArray(row, column, rowCount, columnCount)

public object[,] GetArray( 
   int row,
   int column,
   int rowCount,
   int columnCount
)

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

This example uses the GetArray method.

C#
VB.NET

object[,] arr;
gcSpreadSheet1.ActiveSheet.SetArray(1, 0, new String[,] { { "One", "Two" } });
gcSpreadSheet1.ActiveSheet.SetArray(2, 1, new String[,] { { "Three", "Four" } }, false);
arr = gcSpreadSheet1.ActiveSheet.GetArray(1, 0, 3, 2);
gcSpreadSheet1.ActiveSheet.Cells[3, 3].Text = "The value of the first element in the array is " + arr.GetValue(0, 0).ToString();

Dim arr(,) As Object
GcSpreadSheet1.ActiveSheet.SetArray(1, 0, New String(,) {{"One", "Two"}})
GcSpreadSheet1.ActiveSheet.SetArray(2, 1, New String(,) {{"Three", "Four"}}, False)
arr = GcSpreadSheet1.ActiveSheet.GetArray(1, 0, 3, 2)
GcSpreadSheet1.ActiveSheet.Cells(3, 3).Text = "The value of the first element in the array is " & arr.GetValue(0, 0).ToString()

Target Platforms: Windows Server 2012, Windows RT

Reference

Worksheet Class
Worksheet Members
Overload List