.
| Introducedin | ||||
|---|---|---|---|---|
|
| Description |
|---|
| Excerpt |
|---|
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. |
| Signature | ||||
|---|---|---|---|---|
| ||||
public static Area ImportData(this Worksheet worksheet, Cell cell, Microsoft.SharePoint.SPView view, Microsoft.SharePoint.SPList list, DataImportProperties props) |
| Signature | ||||
|---|---|---|---|---|
| ||||
Public Shared Function ImportData(ByVal worksheet As Worksheet, ByVal cell As Cell, ByVal view As Microsoft.SharePoint.SPView, ByVal list As Microsoft.SharePoint.SPList, ByVal props As DataImportProperties) As Area |
| Parameters |
|---|
| Param | ||||
|---|---|---|---|---|
| ||||
The current Worksheet object which is calling ImportData |
| Param | ||||
|---|---|---|---|---|
| ||||
The cell at which to start entering the imported values. |
| Param | ||||
|---|---|---|---|---|
| ||||
SharePoint View to use as a data source for the Area starting at the given cell |
| Param | ||||
|---|---|---|---|---|
| ||||
SharePoint List associated with the SharePoint View |
| Param | ||||
|---|---|---|---|---|
| ||||
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 | ||
|---|---|---|
|
| Example | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|