Message-ID: <246498869.7619.1711615706034.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7618_630447481.1711615706034" ------=_Part_7618_630447481.1711615706034 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html SharePointIntegration.BindRowData(ExcelTemplate, Microsoft.Share= Point.SPList, String, DataBindingProperties)

SharePointIntegration.BindRowData(ExcelTemplate, Microsoft.SharePoi= nt.SPList, String, DataBindingProperties)

Introduced in build 7.1.0.1855

= =20

Description

=20

Sets a SharePoint List as a data source for a single row in a template.<= /p>=20

C#
=20
public static void BindRowData(this ExcelTemplate template, Microsoft.Share=
Point.SPList list, String dataSourceName, DataBindingProperties properties)
=20
=20
vb.net
=20
Public Shared Sub BindRowData(ByVal template As ExcelTemplate, ByVal list a=
s Microsoft.SharePoint.SPList, ByVal dataSourceName As String, ByVal proper=
ties As DataBindingProperties)
=20
=20

Parameters

=20
template
The curren= t ExcelTemplate object which is calling BindRowData=20
list
SharePoint List to= use as a data source for the template=20
dataSourceName Name of the data source in the template=20
properties
The=20 DataBinding= Properties object which contains information about how the data should = be bound to the template.=20 property Must be specified, but the=20 DataBindingProperties need not be set beforehand. To bind data= to a template with the default=20 DataBindingProperties, pass in=20 ExcelTemplate.CreateDataBindingProperties() as the=20 property value. Otherwise, use the=20 ExcelTemplate.CreateDataBindingProperties() method to generate= a new=20 DataBindingProperties object and set the=20 Dat= aBindingProperties.MaxRows,=20 D= ataBindingProperties.Transpose, and/or=20 DataBindingProperties.WorksheetName properties for the workbook.=20

Exceptions

=20
ArgumentNul= lException
=20 BindRowData will throw this exception if=20 null (C#) or=20 Nothing (VB.NET) is passed to the method.=20
ArgumentExcepti= on
=20

Remarks

=20
=20 Icon=20
=20

This is an extension method for the ExcelTemplate object to be used for = binding SharePoint data to spreadsheets from within SharePoint. To use this= method, you must add a reference to SoftArtisans.OfficeWriter.ExcelWriter.= SharePointIntegration.dll

=20
=20
------=_Part_7618_630447481.1711615706034--