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

Introduced in build 7.1.0.1855

Description

Opens an existing Excel spreadsheet from a SharePoint Document Library.

C#

vb.net

Parameters

excelApplication

The current ExcelApplication object which is opening the file

docLib

SharePoint Document Library that contains the Excel spreadsheet being opened

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 Document Libraries. To use this method, you must add a reference to SoftArtisans.OfficeWriter.ExcelWriter.SharePointIntegration.dll

Examples

C#