Message-ID: <445267560.8725.1711657939512.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8724_535396070.1711657939512" ------=_Part_8724_535396070.1711657939512 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Imports data from a rectangular array of objects to the specified Area. The new data will overwrite values and formulas in the target wor= ksheet cells, but existing formatting will be preserved.
=20public Area ImportData(System.Object[,] data, System.String[] columnNames,= DataImportProperties props)=20
Public Function ImportData(ByVal data As Object(,), ByVal columnNames As St= ring(), ByVal props As DataImportProperties) As Area=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:
A | =20
X | =20
B | =20
Y | =20
C | =20
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:
A | =20
X | =20
B | =20
Y | =20
C | =20
Z | =20
Area
object representing the set of cells populated with the i=
mported values.=20
DataImportProperties importProps =3D wb.CreateDataImportProperties(); importProps.Transpose =3D true; Area importedArea =3D a.ImportData(dataArray, fieldNames, importProps);=20
Dim importProps As DataImportProperties =3D wb.CreateDataImportProperties() importProps.Transpose =3D True Dim importedArea As Area =3D a.ImportData(dataArray, fieldNames, importProp= s)=20