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
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.
=20public Area ImportData(System.Object[][] data)=20
Public Function ImportData(ByVal data As Object()()) As Area=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:
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
Area data =3D a.ImportData(dataArray);=20
Dim data As Area =3D a.ImportData(dataArray)=20