Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

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#
vb.net
  • No labels