The Programmer's Reference

\This section contains a page about every class and method available in SharePoint Integration.

Sections

SharePointIntegration.BindData(ExcelTemplate, Microsoft.SharePoint.SPList, String, DataBindingProperties)

Sets a SharePoint List as a template data source.

SharePointIntegration.BindData(ExcelTemplate, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, String, DataBindingProperties)

Sets a SharePoint View as a template data source.

SharePointIntegration.BindRowData(ExcelTemplate, Microsoft.SharePoint.SPList, String, DataBindingProperties)

Sets a SharePoint List as a data source for a single row in a template.

SharePointIntegration.BindRowData(ExcelTemplate, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, String, DataBindingProperties)

Sets a SharePoint View as a data source for a single row in a template.

SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPList, DataImportProperties)

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.

SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPList)

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.

SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)

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

SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)

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

SharePointIntegration.ImportData(Worksheet, 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.

SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPList)

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.

SharePointIntegration.ImportData(Worksheet, 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.

SharePointIntegration.ImportData(Worksheet, 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.

SharePointIntegration.Open(ExcelApplication, Microsoft.SharePoint.SPDocumentLibrary, String)

Opens an existing Excel spreadsheet from a SharePoint Document Library.

SharePointIntegration.Open(ExcelApplication, Microsoft.SharePoint.SPListItem, String)

Opens an existing Excel spreadsheet that is attached to a SharePoint List Item.

SharePointIntegration.Open(ExcelTemplate, Microsoft.SharePoint.SPDocumentLibrary, String)

Opens a spreadsheet from a SharePoint Document Library.

SharePointIntegration.Open(ExcelTemplate, Microsoft.SharePoint.SPListItem, String)

Opens a spreadsheet from a SharePoint List Item.

SharePointIntegration.Save(ExcelApplication, Workbook, Microsoft.SharePoint.SPDocumentLibrary, String, Boolean)

Saves a specified Workbook as a BIFF8 format (Excel 97 or later) .xls file.

SharePointIntegration.Save(ExcelApplication, Workbook, Microsoft.SharePoint.SPListItem, String)