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

Worksheet.ImportData(System.Data.DataTable, Cell, DataImportPropert= ies)

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, DataImportPr=
operties props)
=20
=20
vb.net
=20
Public Function ImportData(ByVal data As System.Data.DataTable, ByVal cell =
As Cell, ByVal props As DataImportProperties) As Area
=20
=20

Parameters

=20
data
The=20 DataTable to import.=20
startCell
The cell at which to start entering the impo= rted values.=20
props
A=20 DataImportPr= operties object that contains a set of properties that will determine t= he behavior of the data import.=20

Returns

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

Examples

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