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

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

Introduced in build 7.1.0.1855

=20

Description

=20

Opens an existing Excel spreadsheet from a SharePoint Document Library.<= /p>=20

C#
=20
public static Workbook Open(this ExcelApplication excelApplication, Microso=
ft.SharePoint.SPDocumentLibrary docLib, String fileName)
=20
=20
vb.net
=20
Public Shared Function Open(ByVal excelApplication As ExcelApplication, ByV=
al docLib As Microsoft.SharePoint.SPDocumentLibrary, ByVal fileName As Stri=
ng) As Workbook
=20
=20

Parameters

=20
excelApplication
The curre= nt ExcelApplication object which is opening the file=20
docLib
SharePoint Document Library t= hat contains the Excel spreadsheet being opened=20
fileName
The name of the file to o= pen. The 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 fi= le cannot be found or opened, or if ExcelWriter cannot parse the file as a = BIFF8 file.=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 Document Libraries. To use this met= hod, you must add a reference to SoftArtisans.OfficeWriter.ExcelWriter.Shar= ePointIntegration.dll

=20
=20
=20

Examples

=20
C#
=20

          Workbook wb =3D xla.Open(myDocLib, "Report.xls");
        
=20
=20
vb.net
=20
Dim wb As Workbook =3D xla.Open(myDocLib, "Report.xls")
=20
------=_Part_8684_164521568.1711655172423--