SharePointIntegration.Open(ExcelApplication, Microsoft.SharePoint.SPListItem, String)

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#