.
| 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 | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|