Message-ID: <1261315793.10105.1711713013579.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10104_757258845.1711713013579" ------=_Part_10104_757258845.1711713013579 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, DataImportProperties)

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

Introduced in build 7.1.= 0.1855

=20

D= escription

=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, DataImportPrope=
rties props)
=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, ByVal props As DataImportProperties) As Area
=20
=20

Pa= rameters

=20
wor= ksheet
The current Worksheet object which is calling ImportData=20
cell The cell at which to start entering the imported values.=20
view SharePoint View to use as a data source for the Area starting at the give= n cell=20
list SharePoint List associated with the SharePoint View=20
props A=20 DataImportPr= operties object that contains a set of properties that will determine t= he behavior of the data import.=20

Retur= ns

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

Remar= ks

=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

Exam= ples

=20
C#
=20
Area importedArea =3D ws.ImportData(cell, myView, myList, importProps);=20
=20
vb.net
=20
Dim importedArea As Area =3D ws.ImportData(cell, myView, myList, importProp=
s)
=20
------=_Part_10104_757258845.1711713013579--