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.

public static class SharePointIntegration
Public NotInheritable Class SharePointIntegration

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.

Name

Description

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

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

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

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

ImportData(Area, Microsoft.SharePoint.SPList)

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

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

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

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

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

ImportData(Worksheet, Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)

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

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

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

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

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

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

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

Save(ExcelTemplate, Microsoft.SharePoint.SPListItem, String)

Save(ExcelTemplate, Microsoft.SharePoint.SPDocumentLibrary, String, Boolean)