SharePointIntegration.Save(ExcelApplication, Workbook, Microsoft.SharePoint.SPDocumentLibrary, String, Boolean)

Introduced in build 7.1.0.1855

Description

Saves a specified Workbook as a BIFF8 format (Excel 97 or later) .xls file.

C#

vb.net

Parameters

excelApplication

The current ExcelApplication object which is saving the workbook to file

workbook

A Workbook object representing the workbook to save.

docLib

SharePoint Document Library that contains the Excel spreadsheet being opened

fileName

Specifies a file name for the Workbook. ExcelWriter will save the file to the document library using this name. If a file with the same name exists, it will be overwritten by the new Excel file if the overwrite parameter is set to True.

overwrite

Set to True to overwrite an Excel file if one already exists by that name in the Document Library

Exceptions

System.Exception

If there is a problem creating, opening, or writing to the file specified, or reading from the workbook object.

Remarks

Icon

This is an extension method for the ExcelApplication object to be used for saving spreadsheets to SharePoint Document Libraries. To use this method, you must add a reference to SoftArtisans.OfficeWriter.ExcelWriter.SharePointIntegration.dll

Examples

C#