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) — Saves a specified Workbook as a BIFF8 format (Excel 97 or later) .xls file.
• SharePointIntegration.Save(ExcelTemplate, Microsoft.SharePoint.SPDocumentLibrary, String, Boolean) — Generates an Excel binary or OOXML file and saves it to a SharePoint Document Library.
• SharePointIntegration.Save(ExcelTemplate, Microsoft.SharePoint.SPListItem, String) — Generates an Excel binary or OOXML file and saves it as an attachment to a SharePoint list item.