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 SharePointIntegration

SharePointIntegration

Introduced in = build 7.1.0.1855

=20

Description

The SharePointIntegration class contains the extension methods that = allow users to bind SharePoint data sources to Excel spreadsheets as well a= s open and save files in SharePoint lists and document libraries.=20
C#
=20
public static class SharePointIntegration
=20
=20
vb.net
=20
Public NotInheritable Class SharePointIntegratio=
n
=20
=20

Remarks

=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.

Methods

Name

Description

BindData(ExcelTemplate, Microsoft.SharePoint.SPList, String, DataBin= dingProperties)

Sets a SharePoint List as a template data source= .

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

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.

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

Sets a SharePoint View as a data source for a si= ngle row in a template.

ImportData(Area, Microsoft.SharePoint.SPList)

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.

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 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.

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

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.
------=_Part_9740_1278032256.1711701195975--