Message-ID: <1258859756.8181.1711635993452.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8180_898959143.1711635993452" ------=_Part_8180_898959143.1711635993452 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Imports data from an ADO.NET Da= taTable to the specified Area. = The new data will overwrite values and formulas in the target worksheet cells, but existing formatt= ing will be preserved.
=20public Area ImportData(System.Data.DataTable data, DataImportProperties pr= ops)=20
Public Function ImportData(ByVal data As System.Data.DataTable, ByVal props= As DataImportProperties) As Area=20
DataTable
to import.=20
Area
object representing the set of cells populated with the i=
mported values.=20
DataImportProperties importProps =3D wb.CreateDataImportProperties(); importProps.Truncate =3D true; Area importedArea =3D a.ImportData(dt, importProps);=20
Dim importProps As DataImportProperties =3D wb.CreateDataImportProperties() importProps.Truncate =3D True Area importedArea =3D a.ImportData(dt, importProps)=20