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

Introduced in build 7.1.0.1855

Description

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.

C#

vb.net

Parameters

area

The current Area object which is calling ImportData

view

SharePoint View to use as a data source for the Area

list

SharePoint List associated with the SharePoint View

Returns

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

Remarks

Icon

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

Examples

C#