Message-ID: <410627949.8855.1711664797872.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8854_1153305053.1711664797872" ------=_Part_8854_1153305053.1711664797872 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 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.
=20public Area ImportData(System.Object[,] data, Cell cell)=20
Public Function ImportData(ByVal data As Object(,), ByVal cell As Cell) 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
Area importedArea =3D ws.ImportData(dataArray, cel);=20
Dim importedArea As Area =3D ws.ImportData(dataArray, cel)=20