Message-ID: <1283834023.8079.1711631530232.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8078_1128441240.1711631530232" ------=_Part_8078_1128441240.1711631530232 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html SharePointIntegration.Open(ExcelApplication, Microsoft.SharePoin= t.SPListItem, String)

SharePointIntegration.Open(ExcelApplication, Microsoft.SharePoint.S= PListItem, String)

Introduced in build 7.1.0.1855

=20

Description

=20

Opens an existing Excel spreadsheet that is attached to a SharePoint Lis= t Item.

=20
C#
=20
public static Workbook Open(this ExcelApplication excelApplication, Microso=
ft.SharePoint.SPListItem listItem, String fileName)
=20
=20
vb.net
=20
Public Shared Function Open(ByVal excelApplication As ExcelApplication, ByV=
al listItem As Microsoft.SharePoint.SPListItem, ByVal fileName As String) A=
s Workbook
=20
=20

Parameters

=20
excelApplication
The current Exce= lApplication object which is opening the file=20
listItem
SharePoint List Item to which th= e file is attached=20
fileName
The name of the file to open. Th= e file must be a BIFF8 format (Excel 97 or later) .xls or .xlt file.=20

Returns

A=20 Workbook object repr= esenting the file opened.=20

Exceptions

=20
System.Exception
If the file cann= ot be found or opened, or if ExcelWriter cannot parse the file as a BIFF8 f= ile.=20

Remarks

=20

ExcelWriter supports Excel's BIFF8 (Excel 97 or later) format only. Do n= ot use this method to open BIFF7 (Excel 95) files.

=20
=20 Icon=20
=20

This is an extension method for the ExcelApplication object to be used f= or opening spreadsheets from SharePoint List Items. To use this method, you= must add a reference to SoftArtisans.OfficeWriter.ExcelWriter.SharePointIn= tegration.dll

=20
=20
=20

Examples

=20
C#
=20

          Workbook wb =3D xla.Open(myListItem, "Report.xls");
        
=20
=20
vb.net
=20
Dim wb As Workbook =3D xla.Open(myListItem, "Report.xls")
= =20
------=_Part_8078_1128441240.1711631530232--