Message-ID: <813463492.8529.1711648524689.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8528_1308317875.1711648524689" ------=_Part_8528_1308317875.1711648524689 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Worksheet.ImportData

Worksheet.ImportData

=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

Overload

Description

ImportData(Object()(), Cell)

Imports data from a two-dimensional array of obj= ects to cells in the worksheet.

ImportData(Object()(), String(), Cell, DataImportProperties)

Imports data from a two-dimensional array of obj= ects to cells in the worksheet. The new data will overwrite values and formulas in the target works= heet cells, but existing formatting will be preserved.

ImportData(Object(,), Cell)

Imports data from a rectangular array of objects= to cells in the worksheet. The new data will overwrite values and formulas in the target worksheet= cells, but existing formatting will be preserved.

ImportData(Object(,), String(), Cell, DataImportProperties)

=
Imports data from a rectangular array of objects= to cells in the worksheet. The new data will overwrite values and formulas in the target worksheet= cells, but existing formatting will be preserved.

ImportData(System.Data.IDataReader, Cell)

Imports data from an IDataReader to cells in the worksheet. The new data = will overwrite values an= d formulas in the target worksheet cells, but existing formatting will be p= reserved.

ImportData(System.Data.IDataReader, Cell, DataImportProperties)=

Imports data from an IDataReader to cells in the worksheet. The new data = will overwrite values an= d formulas in the target worksheet cells, but existing formatting will be p= reserved.

ImportData(System.Data.DataTable, Cell)

Imports data from an ADO.NET DataTable to cells in the worksheet. The new= data will overwrite val= ues and formulas in the target worksheet cells, but existing formatting wil= l be preserved.

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

Imports data from an ADO.NET DataTable to cells in the worksheet. The new= data will overwrite val= ues and formulas in the target worksheet cells, but existing formatting wil= l be preserved.

ImportData(System.Data.DataView, Cell)

Imports data from an ADO.NET DataView to cells in the worksheet. The new = data will overwrite valu= es and formulas in the target worksheet cells, but existing formatting will= be preserved.

ImportData(System.Data.DataView, Cell, DataImportProperties)

Imports data from an ADO.NET DataView to cells in the worksheet. The new = data will overwrite valu= es and formulas in the target worksheet cells, but existing formatting will= be preserved.
=20

Share= Point Integration Extension Methods

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

Overload

Description

ImportData(Cell, Microsoft.SharePoint.SPList, DataImportProperties)=

Imports data from a SharePoint List to cells in = the worksheet. The new data will overwrite values and formulas in the targe= t worksheet cells, but existing formatting will be preserved.

ImportData(Cell, Microsoft.SharePoint.SPList)

Imports data from a SharePoint List to cells in = the worksheet. The new data will overwrite values and formulas in the targe= t worksheet cells, but existing formatting will be preserved.

ImportData(Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.= SPList, DataImportProperties)

Imports data from a SharePoint View to cells in = the worksheet. The new data will overwrite values and formulas in the targe= t worksheet cells, but existing formatting will be preserved.

ImportData(Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.= SPList)

Imports data from a SharePoint View to cells in = the worksheet. The new data will overwrite values and formulas in the targe= t worksheet cells, but existing formatting will be preserved.
------=_Part_8528_1308317875.1711648524689--