Message-ID: <612381072.10377.1711723047734.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10376_1526542483.1711723047718" ------=_Part_10376_1526542483.1711723047718 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPVi= ew, Microsoft.SharePoint.SPList, DataImportProperties)

SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView,= Microsoft.SharePoint.SPList, DataImportProperties)

Introduced in build 7.1.0.1855=20

Description=

=20

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

=20
C#
=20
public static Area ImportData(this Area area, Microsoft.SharePoint.SPView v=
iew, Microsoft.SharePoint.SPList list, DataImportProperties props)
=20
=20
vb.net
=20
Public Shared Function ImportData(ByVal area As Area, ByVal view As Microso=
ft.SharePoint.SPView, ByVal list As Microsoft.SharePoint.SPList, ByVal prop=
s As DataImportProperties) As Area
=20
=20

Parameters=20

area
The curr= ent Area object which is calling ImportData=20
view
SharePoi= nt View to use as a data source for the template=20
list
SharePoi= nt 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

Returns

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

Remarks

=20
=20 Icon=20
=20

This is an extension method for the Area object to be used for binding S= harePoint data to spreadsheets from within SharePoint. To use this method, = you must add a reference to SoftArtisans.OfficeWriter.ExcelWriter.SharePoin= tIntegration.dll

=20
=20
=20

Examples

= =20
C#
=20

          DataImportProperties importProps =3D wb.CreateDataImportPropertie=
s();
          importProps.Transpose =3D true;
          Area importedArea =3D a.ImportData(myView, myList, importProps);
        
=20
=20
vb.net
=20

          Dim importProps As DataImportProperties =3D wb.CreateDataImportPr=
operties()
          importProps.Transpose =3D True
          Dim importedArea As Area =3D a.ImportData(myView, myList, importP=
rops)
        
=20
------=_Part_10376_1526542483.1711723047718--