{introducedin:7.1.0.1855}
{description}
{excerpt}The SharePointIntegration class contains the extension methods that allow users to bind SharePoint data sources to Excel spreadsheets as well as open and save files in SharePoint lists and document libraries.
{excerpt}
{signature:C#}
public static class SharePointIntegration
{signature}
{remarks}
The SharePointIntegration class is to be used on a SharePoint server to use the ExcelTemplate, ExcelApplication, Worksheet, and Area objects with SharePoint.  SharePointIntegration belongs to the SoftArtisans.OfficeWriter.ExcelWriter.SharePointIntegration namespace, which has the Microsoft.SharePoint class as a dependency.  Additionally, the SharePointIntegration class belongs in a separate DLL, SoftArtisans.OfficeWriter.ExcelWriter.SharePoinIntegration.dll, which must be added to the bin directory of your project.

SharePointIntegration is a static class which cannot directly be instantiated, but rather contains extension methods for the [ExcelApplication], [ExcelTemplate], [Worksheet], and [Area] objects.  Use SharePointIntegration extensions just as you would the other methods of each object, remembering to add references to the SoftArtisans.OfficeWriter.ExcelWriter and Microsoft.SharePoint namespaces.
{remarks}
{methods}
|| Name || Description ||
| [BindData(ExcelTemplate, Microsoft.SharePoint.SPList, String, DataBindingProperties)|SharePointIntegration.BindData(ExcelTemplate, Microsoft.SharePoint.SPList, String, DataBindingProperties)] | {excerpt-include:SharePointIntegration.BindData(ExcelTemplate, Microsoft.SharePoint.SPList, String, DataBindingProperties)|nopanel=true} |
| [BindData(ExcelTemplate, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, String, DataBindingProperties)|SharePointIntegration.BindData(ExcelTemplate, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, String, DataBindingProperties)] | {excerpt-include:SharePointIntegration.BindData(ExcelTemplate, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, String, DataBindingProperties)|nopanel=true} |
| [BindRowData(ExcelTemplate, Microsoft.SharePoint.SPList, String, DataBindingProperties)|SharePointIntegration.BindRowData(ExcelTemplate, Microsoft.SharePoint.SPList, String, DataBindingProperties)] | {excerpt-include:SharePointIntegration.BindRowData(ExcelTemplate, Microsoft.SharePoint.SPList, String, DataBindingProperties)|nopanel=true} |
| [BindRowData(ExcelTemplate, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, String, DataBindingProperties)|SharePointIntegration.BindRowData(ExcelTemplate, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, String, DataBindingProperties)] | {excerpt-include:SharePointIntegration.BindRowData(ExcelTemplate, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, String, DataBindingProperties)|nopanel=true} |
| [ImportData(Area, Microsoft.SharePoint.SPList)|SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPList)] | {excerpt-include:SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPList)|nopanel=true} |
| [ImportData(Area, Microsoft.SharePoint.SPList, DataImportProperties)|SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPList, DataImportProperties)] | {excerpt-include:SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPList, DataImportProperties)|nopanel=true} |
| [ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)|SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)] | {excerpt-include:SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)|nopanel=true} |
| [ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)|SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)] | {excerpt-include:SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)|nopanel=true} |
| [ImportData(Worksheet, Cell, Microsoft.SharePoint.SPList)|SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPList)] | {excerpt-include:SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPList)|nopanel=true} |
| [ImportData(Worksheet, Cell, Microsoft.SharePoint.SPList, DataImportProperties)|SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPList, DataImportProperties)] | {excerpt-include:SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPList, DataImportProperties)|nopanel=true} |
| [ImportData(Worksheet, Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)|SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)] | {excerpt-include:SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)|nopanel=true} |
| [ImportData(Worksheet, Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)|SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)] | {excerpt-include:SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)|nopanel=true} |
| [Open(ExcelApplication, Microsoft.SharePoint.SPDocumentLibrary, String)|SharePointIntegration.Open(ExcelApplication, Microsoft.SharePoint.SPDocumentLibrary, String)] | {excerpt-include:SharePointIntegration.Open(ExcelApplication, Microsoft.SharePoint.SPDocumentLibrary, String)|nopanel=true} |
| [Open(ExcelApplication, Microsoft.SharePoint.SPListItem, String)|SharePointIntegration.Open(ExcelApplication, Microsoft.SharePoint.SPListItem, String)] | {excerpt-include:SharePointIntegration.Open(ExcelApplication, Microsoft.SharePoint.SPListItem, String)|nopanel=true} |
| [Open(ExcelTemplate, Microsoft.SharePoint.SPDocumentLibrary, String)|SharePointIntegration.Open(ExcelTemplate, Microsoft.SharePoint.SPDocumentLibrary, String)] | {excerpt-include:SharePointIntegration.Open(ExcelTemplate, Microsoft.SharePoint.SPDocumentLibrary, String)|nopanel=true} |
| [Open(ExcelTemplate, Microsoft.SharePoint.SPListItem, String)|SharePointIntegration.Open(ExcelTemplate, Microsoft.SharePoint.SPListItem, String)] | {excerpt-include:SharePointIntegration.Open(ExcelTemplate, Microsoft.SharePoint.SPListItem, String)|nopanel=true} |
| [Save(ExcelApplication, Workbook, Microsoft.SharePoint.SPListItem, String)|SharePointIntegration.Save(ExcelApplication, Workbook, Microsoft.SharePoint.SPListItem, String)] | {excerpt-include:SharePointIntegration.Save(ExcelApplication, Workbook, Microsoft.SharePoint.SPListItem, String)|nopanel=true} |
| [Save(ExcelApplication, Workbook, Microsoft.SharePoint.SPDocumentLibrary, String, Boolean)|SharePointIntegration.Save(ExcelApplication, Workbook, Microsoft.SharePoint.SPDocumentLibrary, String, Boolean)] | {excerpt-include:SharePointIntegration.Save(ExcelApplication, Workbook, Microsoft.SharePoint.SPDocumentLibrary, String, Boolean)|nopanel=true} |
| [Save(ExcelTemplate, Microsoft.SharePoint.SPListItem, String)|SharePointIntegration.Save(ExcelTemplate, Microsoft.SharePoint.SPListItem, String)] | {excerpt-include:SharePointIntegration.Save(ExcelTemplate, Microsoft.SharePoint.SPListItem, String)|nopanel=true} |
| [Save(ExcelTemplate, Microsoft.SharePoint.SPDocumentLibrary, String, Boolean)|SharePointIntegration.Save(ExcelTemplate, Microsoft.SharePoint.SPDocumentLibrary, String, Boolean)] | {excerpt-include:SharePointIntegration.Save(ExcelTemplate, Microsoft.SharePoint.SPDocumentLibrary, String, Boolean)|nopanel=true} |