Introduced in build 7.1.0.1855
Description
Imports data from a SharePoint List to the specified Area. The new data will overwrite values and formulas in the target worksheet cells, but existing formatting will be preserved.
Signature: C#
Signature: VB.NET
Parameters
area
The current Area object which is calling ImportData
list
SharePoint List to use as a data source for the Area
props
A DataImportProperties object that contains a set of properties that will determine the behavior of the data import.
Returns
An Area object representing the set of cells populated with the imported values.
Remarks
 | 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#
vb.net