.
Overload |
Description |
|---|---|
| Imports data from a two-dimensional array of objects to cells in the worksheet. | |
ImportData(Object()(), String(), Cell, DataImportProperties) |
Imports data from a two-dimensional array of objects to cells in the worksheet. The new data will overwrite values and formulas in the target worksheet cells, but existing formatting will be preserved. |
| Imports data from a rectangular array of objects to cells in the worksheet. The new data will overwrite values and formulas in the target worksheet cells, but existing formatting will be preserved. | |
| Imports data from a rectangular array of objects to cells in the worksheet. The new data will overwrite values and formulas in the target worksheet cells, but existing formatting will be preserved. | |
| Imports data from an IDataReader to cells in the worksheet. The new data will overwrite values and formulas in the target worksheet cells, but existing formatting will be preserved. | |
ImportData(System.Data.IDataReader, Cell, DataImportProperties) |
Imports data from an IDataReader to cells in the worksheet. The new data will overwrite values and formulas in the target worksheet cells, but existing formatting will be preserved. |
| Imports data from an ADO.NET DataTable to cells in the worksheet. The new data will overwrite values and formulas in the target worksheet cells, but existing formatting will be preserved. | |
ImportData(System.Data.DataTable, Cell, DataImportProperties) |
Imports data from an ADO.NET DataTable to cells in the worksheet. The new data will overwrite values and formulas in the target worksheet cells, but existing formatting will be preserved. |
| Imports data from an ADO.NET DataView to cells in the worksheet. The new data will overwrite values and formulas in the target worksheet cells, but existing formatting will be preserved. | |
ImportData(System.Data.DataView, Cell, DataImportProperties) |
Imports data from an ADO.NET DataView to cells in the worksheet. The new data will overwrite values and formulas in the target worksheet cells, but existing formatting will be preserved. |
SharePoint Integration Extension Methods
Overload |
Description |
|---|---|
ImportData(Cell, Microsoft.SharePoint.SPList, DataImportProperties) |
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. |
| 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. | |
ImportData(Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties) |
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. |
ImportData(Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList) |
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. |