Message-ID: <638136666.8383.1711644130490.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8382_431272413.1711644130490" ------=_Part_8382_431272413.1711644130490 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.Shar= ePoint.SPList)

SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePo= int.SPList)

Description

=20

Imports data from a SharePoint List to cells in the worksheet. The new d= ata will overwrite values and formulas in the target worksheet cells, but e= xisting formatting will be preserved.

=20
C#
=20
public static Area ImportData(this Worksheet worksheet, Cell cell, Microsof=
t.SharePoint.SPList list)
=20
=20
vb.net
=20
Public Shared Function ImportData(ByVal worksheet As Worksheet, ByVal cell =
As Cell, ByVal list As Microsoft.SharePoint.SPList) As Area
=20
=20

Parameters

=20
worksheet
The current Worksheet object which is= calling ImportData=20
cell
The cell at which to start entering the importe= d values.=20
list
SharePoint List to use as a data source for the= Area starting at the given cell=20

Returns

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

Remarks

=20
=20 Icon=20
=20

This is an extension method for the Worksheet object to be used for bind= ing SharePoint data to spreadsheets from within SharePoint. To use this met= hod, you must add a reference to SoftArtisans.OfficeWriter.ExcelWriter.Shar= ePointIntegration.dll

=20
=20
=20

Examples

=20
C#
=20
Area importedArea =3D ws.ImportData(cell, myList);
=20
=20
vb.net
=20
Dim importedArea As Area =3D ws.ImportData(cell, myList)
=20
------=_Part_8382_431272413.1711644130490--