Message-ID: <1548963237.8619.1711652349530.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8618_1533625733.1711652349530" ------=_Part_8618_1533625733.1711652349530 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.SPView, Microsoft.SharePoint.SPList)

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

Introduced in build 7.1.0.1855

=20

Description

=20

Imports data from a SharePoint View 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.SPView view, Microsoft.SharePoint.SPList list)
=20
=20
vb.net
=20
Public Shared Function ImportData(ByVal worksheet As Worksheet, ByVal cell =
As Cell, ByVal view As Microsoft.SharePoint.SPView, ByVal list As Microsoft=
.SharePoint.SPList) As Area
=20
=20

Parameters

=20
worksheet
The curre= nt Worksheet object which is calling ImportData=20
cell
The cell at which t= o start entering the imported values.=20
view
SharePoint View to = use as a data source for the Area starting at the given cell=20
list
SharePoint List ass= ociated with the SharePoint View=20

Returns

An=20 Area object representin= g 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, myView, myList);
=20
=20
vb.net
=20
Dim importedArea As Area =3D ws.ImportData(cell, myView, myList)
=20
------=_Part_8618_1533625733.1711652349530--