Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

Excerpt

Imports data from a rectangular array of objects to the specified Area. The new data will overwrite values and formulas in the target worksheet cells, but existing formatting will be preserved.

Signature
C#
C#
 public Area ImportData(System.Object[,] data)
{signature}{signature:
}
Signature
vb.net
vb.net
Public Function ImportData(ByVal data As Object(,)) As Area
{signature}
{parameters}
{param:data}A rectangular array of values to import to the worksheet. The first dimension corresponds to row and the second to column.
        Thus, an array of data  \{ \
Parameters
Param
data
data

A rectangular array of values to import to the worksheet. The first dimension corresponds to row and the second to column.
Thus, an array of data { {"A","X"

\

},

\

{"B","Y"

\

},

\

{"C","Z"

\

}

\

}

would

be

inserted

into

the

worksheet

as:

|A|X| |B|Y| |C|Z| {param} {returns}An {{Area}} object representing the set of cells populated with the imported values.{returns} {example}{code:csharp|title=C#}

A

X

B

Y

C

Z

Returns

An Area object representing the set of cells populated with the imported values.

Example
Code Block
csharp
csharp
titleC#

Area importedArea = a.ImportData(dataArray);
{code} {code:vbnet|title=
Code Block
vbnet
vbnet
titlevb.net
}

Dim importedArea As Area = a.ImportData(dataArray)
{code} {example} {scrollbar}
Scrollbar