Message-ID: <756689298.9741.1711701195975.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_9740_1278032256.1711701195975" ------=_Part_9740_1278032256.1711701195975 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
public static class SharePointIntegration=20
Public NotInheritable Class SharePointIntegratio= n=20
The SharePointIntegration class is to be used on a SharePoint server to = use the ExcelTemplate, ExcelApplication, Worksheet, and Area objects with S= harePoint. SharePointIntegration belongs to the SoftArtisans.OfficeWriter.E= xcelWriter.SharePointIntegration namespace, which has the Microsoft.SharePo= int class as a dependency. Additionally, the SharePointIntegration class be= longs in a separate DLL, SoftArtisans.OfficeWriter.ExcelWriter.SharePoinInt= egration.dll, which must be added to the bin directory of your project.
SharePointIntegration is a static class which cannot directly be instant= iated, 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 Microsof= t.SharePoint namespaces.
Name |
Description |
---|---|
BindData(ExcelTemplate, Microsoft.SharePoint.SPList, String, DataBin= dingProperties) |
Sets a SharePoint List as a template data source= . |
Sets a SharePoint View as a template data source= . | |
BindRowData(ExcelTemplate, Microsoft.SharePoint.SPList, String, Data= BindingProperties) |
Sets a SharePoint List as a data source for a si= ngle row in a template. |
Sets a SharePoint View as a data source for a si= ngle row in a template. | |
Imports data from a SharePoint List to the speci= fied Area. The new data will overwrite v= alues and formulas in the target worksheet cells, but existing formatting w= ill be preserved. | |
ImportData(Area, Microsoft.SharePoint.SPList, DataImportProperties)<= /a> |
Imports data from a SharePoint List to the speci= fied Area. The new data will overwrite v= alues and formulas in the target worksheet cells, but existing formatting w= ill be preserved. |
ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.S= PList, DataImportProperties) |
Imports data from a SharePoint View to the speci= fied Area. The new data will overwrite v= alues and formulas in the target worksheet cells, but existing formatting w= ill be preserved. |
ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.S= PList) |
Imports data from a SharePoint View to the speci= fied Area. The new data will overwrite v= alues and formulas in the target worksheet cells, but existing formatting w= ill be preserved. |
Imports data from a SharePoint List to cells in = the worksheet. The new data will overwrite values and formulas in the targe= t worksheet cells, but existing formatting will be preserved. | |
ImportData(Worksheet, Cell, Microsoft.SharePoint.SPList, DataImportP= roperties) |
Imports data from a SharePoint List to cells in = the worksheet. The new data will overwrite values and formulas in the targe= t worksheet cells, but existing formatting will be preserved. |
Imports data from a SharePoint View to cells in = the worksheet. The new data will overwrite values and formulas in the targe= t worksheet cells, but existing formatting will be preserved. | |
ImportData(Worksheet, Cell, Microsoft.SharePoint.SPView, Microsoft.S= harePoint.SPList) |
Imports data from a SharePoint View to cells in = the worksheet. The new data will overwrite values and formulas in the targe= t worksheet cells, but existing formatting will be preserved. |
Open(ExcelApplication, Microsoft.SharePoint.SPDocumentLibrary, Strin= g) |
Opens an existing Excel spreadsheet from a Share= Point Document Library. |
Open(ExcelApplication, Microsoft.SharePoint.SPListItem, String)<= /p> |
Opens an existing Excel spreadsheet that is atta= ched to a SharePoint List Item. |
Open(ExcelTemplate, Microsoft.SharePoint.SPDocumentLibrary, String)<= /a> |
Opens a spreadsheet from a SharePoint Document L= ibrary. |
Open(ExcelTemplate, Microsoft.SharePoint.SPListItem, String) = |
Opens a spreadsheet from a SharePoint List Item.= |
Save(ExcelApplication, Workbook, Microsoft.SharePoint.SPListItem, St= ring) |
Saves a specified Workbook as a BIFF8 format (Excel 97 or later) .xls file. |
Save(ExcelApplication, Workbook, Microsoft.SharePoint.SPDocumentLibr= ary, String, Boolean) |
Saves a specified Workbook as a BIFF8 format (Excel 97 or later) .xls file. |
Save(ExcelTemplate, Microsoft.SharePoint.SPListItem, String) = |
Generates an Excel binary or OOXML file and save= s it as an attachment to a SharePoint list item. |
Save(ExcelTemplate, Microsoft.SharePoint.SPDocumentLibrary, String, = Boolean) |
Generates an Excel binary or OOXML file and save= s it to a SharePoint Document Library. |