Message-ID: <266640576.9029.1711673284984.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_9028_29659240.1711673284984" ------=_Part_9028_29659240.1711673284984 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Worksheet.ImportData(Object(,), String(), Cell, DataImportProper= ties)

Worksheet.ImportData(Object(,), String(), Cell, DataImportPropertie= s)

Description

=20

Imports data from a rectangular array of objects to cells in the workshe= et. The new data will overwrite= values and formulas in the target worksheet cells, but existing for= matting will be preserved.

=20
C#
=20
 public Area ImportData(System.Object[,] data, System.String[] columnNames,=
 Cell cell, DataImportProperties props)
=20
=20
vb.net
=20
Public Function ImportData(ByVal data As Object(,), ByVal columnNames As St=
ring(), ByVal cell As Cell, ByVal props As DataImportProperties) As Area
=20
=20

Parameters

=20
data
=20

A rectangular array of values to import to the worksheet. The first dime= nsion 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:

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

A

X

B

Y

C

Z

=20

If you enable DataImportProperties.Transpose , the format will be [ro= w][column], so:
{ {"A","B","C"},{"= X","Y","Z"} } would be inserted 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
columnNames
An array of column names for the imported d= ata.=20 columnNames and the column dimension of=20 data must contain the same number of elements.=20
startCell
The cell at which to start entering the importe= d values.=20
props
A=20 DataImportPr= operties object that contains a set of properties that will determine t= he behavior of the data import.=20

Returns

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

Examples

=20
C#
=20
Area importedArea =3D ws.ImportData(dataArray, fieldNames, cel, importProps=
);
=20
=20
vb.net
=20
Dim importedArea As Area =3D ws.ImportData(dataArray, fieldNames, cel, impo=
rtProps)
=20
------=_Part_9028_29659240.1711673284984--