Page History

{introducedin:7.1.0.1855}
{description}
{excerpt}Opens an existing Excel spreadsheet from a SharePoint Document Library.{excerpt}
{signature:C#}
public static Workbook Open(this ExcelApplication excelApplication, Microsoft.SharePoint.SPDocumentLibrary docLib, String fileName)
{signature}{signature:vb.net}
Public Shared Function Open(ByVal excelApplication As ExcelApplication, ByVal docLib As Microsoft.SharePoint.SPDocumentLibrary, ByVal fileName As String) As Workbook
{signature}
{parameters}
{param:excelApplication}The current ExcelApplication object which is opening the file
{param}
{param:docLib}SharePoint Document Library that contains the Excel spreadsheet being opened
{param}
{param:fileName}The name of the file to open. The file must be a BIFF8 format \(Excel 97 or later\) .xls or .xlt file.{param}
{returns}A [Workbook|Workbook] object representing the file opened.{returns}
{exceptions}
{exception:System.Exception}If the file cannot be found or opened, or if ExcelWriter cannot parse the file as a BIFF8 file.{exception}
{remarks}
ExcelWriter supports  Excel's BIFF8 \(Excel 97 or later\) format only.  Do not use  this method  to open BIFF7 \(Excel 95\) files.
{note}This is an extension method for the ExcelApplication object to be used for opening spreadsheets from SharePoint Document Libraries.  To use this method, you must add a reference to SoftArtisans.OfficeWriter.ExcelWriter.SharePointIntegration.dll{note}
{remarks}
{example}{code:csharp|title=C#}

          Workbook wb = xla.Open(myDocLib, "Report.xls");
        {code}
{code:vb.net|title=vb.net}
Dim wb As Workbook = xla.Open(myDocLib, "Report.xls"){code}

{example}