Skip to end of metadata
Go to start of metadata

Introduced in build 7.1.0.1855

Description

Opens an existing Excel spreadsheet that is attached to a SharePoint List Item.

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

Icon

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
  • No labels