Message-ID: <199582563.10455.1711725056906.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10454_1307003618.1711725056906" ------=_Part_10454_1307003618.1711725056906 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Worksheet.ImportData(System.Data.DataTable, Cell)

Worksheet.ImportData(System.Data.DataTable, Cell)

Description

=20

Imports data from an ADO.NET Da= taTable to cells in the worksheet. The new data will overwrite values and formulas in th= e target worksheet cells, but existing formatting will be preserved.

=20
C#
=20
 public Area ImportData(System.Data.DataTable data, Cell cell)
=20
=20
vb.net
=20
Public Function ImportData(ByVal data As System.Data.DataTable, ByVal cell =
As Cell) As Area
=20
=20

Para= meters

=20
data
= The=20 DataTable to import.=20
start= Cell
The cell at which to start entering the imported values.=20

Returns=

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

Exampl= es

=20
C#
=20
Area importedArea =3D ws.ImportData(dataDT, cel);
=20
=20
vb.net
=20
Dim importedArea As Area =3D ws.ImportData(dataDT, cel)
=20
------=_Part_10454_1307003618.1711725056906--