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
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.
=20public static Area ImportData(this Area area, Microsoft.SharePoint.SPView v= iew, Microsoft.SharePoint.SPList list, DataImportProperties props)=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
Area
object representing the set of cells populated with the i=
mported values.=20
DataImportProperties importProps =3D wb.CreateDataImportPropertie= s(); importProps.Transpose =3D true; Area importedArea =3D a.ImportData(myView, myList, importProps);=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