Introducedin | ||||
---|---|---|---|---|
|
Description |
---|
Excerpt |
---|
Opens an existing Excel spreadsheet that is attached to a SharePoint List Item. |
Signature | ||||
---|---|---|---|---|
| ||||
public static Workbook Open(this ExcelApplication excelApplication, Microsoft.SharePoint.SPListItem listItem, String fileName) |
Signature | ||||
---|---|---|---|---|
| ||||
Public Shared Function Open(ByVal excelApplication As ExcelApplication, ByVal listItem As Microsoft.SharePoint.SPListItem, ByVal fileName As String) As Workbook |
Parameters |
---|
Param | ||||
---|---|---|---|---|
| ||||
The current ExcelApplication object which is opening the file |
Param | ||||
---|---|---|---|---|
| ||||
SharePoint List Item to which the file is attached |
Param | ||||
---|---|---|---|---|
| ||||
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 |
---|
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.
|
Example | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|