Introduced in build 7.1.0.1855
Description
Opens an existing Excel spreadsheet that is attached to a SharePoint List Item.
Signature: C#
Signature: VB.NET
Parameters
excelApplication
The current ExcelApplication object which is opening the file
listItem
SharePoint List Item to which the file is attached
fileName
The name of the file to open. The file must be a BIFF8 format (Excel 97 or later) .xls or .xlt file.
Returns
A Workbook object representing the file opened.
Exceptions
System.Exception
If the file cannot be found or opened, or if ExcelWriter cannot parse the file as a BIFF8 file.
Remarks
ExcelWriter supports Excel's BIFF8 (Excel 97 or later) format only. Do not use this method to open BIFF7 (Excel 95) files.
 | 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 |
Examples
C#
vb.net