Page History

...

{introducedin:7.1.0.1855

...

}
{description}
{excerpt}Opens an existing Excel spreadsheet that is attached to a SharePoint List Item.{excerpt}
{signature:C#}
public static Workbook Open(this ExcelApplication excelApplication, Microsoft.SharePoint.SPListItem listItem, String fileName)

{signature}{signature:vb.net

}
Public Shared Function Open(ByVal excelApplication As ExcelApplication, ByVal listItem As Microsoft.SharePoint.SPListItem, ByVal fileName As String) As Workbook

...

The current ExcelApplication object which is opening the file

...

SharePoint List Item to which the file is attached

...

The name of the file to open. The file must be a BIFF8 format (Excel 97 or later) .xls or .xlt file.

{signature}
{parameters}
{param:excelApplication}The current ExcelApplication object which is opening the file
{param}
{param:listItem}
SharePoint List Item to which the file is attached
{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 List Items.  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(myListItem, "Report.xls");
        

{code}
{code:vb.net

|title=vb.net

}
Dim wb As Workbook = xla.Open(myListItem, "Report.xls"){code}

{example}