Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Introducedin
7.1.0.1855
7.1.0.1855
Description

Excerpt

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

Signature
C#
C#
public static Area ImportData(this Worksheet worksheet, Cell cell, Microsoft.SharePoint.SPList list)
Signature
vb.net
vb.net
Public Shared Function ImportData(ByVal worksheet As Worksheet, ByVal cell As Cell, ByVal list As Microsoft.SharePoint.SPList) As Area
Parameters
Param
worksheet
worksheet

The current Worksheet object which is calling ImportData

Param
cell
cell

The cell at which to start entering the imported values.

Param
list
list

SharePoint List to use as a data source for the Area starting at the given cell

Returns

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

Remarks
Note

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

Example
Code Block
csharp
csharp
titleC#
Area importedArea = ws.ImportData(cell, myList);
Code Block
vbnet
vbnet
titlevb.net
Dim importedArea As Area = ws.ImportData(cell, myList)