Message-ID: <1332190536.10141.1711714492668.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10140_1899171871.1711714492668" ------=_Part_10140_1899171871.1711714492668 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Area.ImportData(Object()())

Area.ImportData(Object()())

Description

= =20

Imports data from a two-dimensional array of objects to the specified Area . The new data will overwrite values and formulas in the targe= t worksheet cells, but existing formatting will be preserved.

=20
C#
=20
 public Area ImportData(System.Object[][] data)
=20
=20
vb.net
=20
Public Function ImportData(ByVal data As Object()()) As Area
=20
=20

Parameters

=20
data
=20

A two-dimensional array of values to import to the worksheet. The first = dimension corresponds to row and the second to column (that is, Object[row]= [column]).
Thus, an array of data { {"A","X"},{&q= uot;B","Y"},{"C","Z"} } would be inserte= d into the worksheet as:

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

A

X

B

Y

C

Z

=20

Returns

An=20 Area object representing the set of cells populated with the i= mported values.=20

Examples

=20
C#
=20
Area data =3D a.ImportData(dataArray);
=20
=20
vb.net
=20
Dim data As Area =3D a.ImportData(dataArray)
=20
------=_Part_10140_1899171871.1711714492668--