Page tree
Skip to end of metadata
Go to start of metadata

Introduced in build 7.1.0.1855

Description

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

C#
vb.net

Parameters

worksheet
The current Worksheet object which is calling ImportData
cell
The cell at which to start entering the imported values.
view
SharePoint View to use as a data source for the Area starting at the given cell
list
SharePoint List associated with the SharePoint View
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

Icon

This is an extension method for the Worksheet 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
  • No labels