Message-ID: <54735484.10063.1711711145672.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10062_459858891.1711711145672" ------=_Part_10062_459858891.1711711145672 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html ExcelApplication

ExcelApplication

Description

ExcelApplication is the main class for pure code-based workboo= k generation (for information about template-based workbook generation, see= =20 ExcelTemplate). This class is an= engine used to open, create, and write (save or stream to a browser) workb= ooks. A single instance of ExcelApplication can generate multiple workbooks= .=20
C#
=20
 public class ExcelApplication
=20
=20
vb.net
=20
Public Class ExcelApplication
=20
=20

Remarks

=20

A generated workbook is represented by the Workbook class.

To create an instance of ExcelApplication:

In C#:

In VB.NET:

Properties

Name

Description

LicenseKey

The property sets or returns the license key tha= t enables ExcelWriter. The key is stored in the registry. It contains infor= mation about ExcelWriter, including product name, platform, and version.

Version

Returns the exact version of ExcelWriter. The fo= rmat of the version string returned is:

Methods

Name

Description

Create(FileFormat)

Creates a new workbook containing 1 workshee= t, in the specified file format. The sheet is blank when the workbook is cr= eated, and standard font, style, and format settings applied.

ExcelApplication()

Creates a new ExcelApplication object

Open(ExcelTemplate)

Opens a Workbo= ok from an ExcelTemplate obj= ect.

Open(String)

Opens an existing Excel spreadsheet.

Open(String, String)

Opens an existing Excel spreadsheet.

Open(System.IO.Stream)

Opens an Excel workbook from a stream and return= s a Workbook object.

Open(System.IO.Stream, String)

Opens an Excel workbook from a stream and return= s a Workbook object.

Save(Workbook, String)

Saves a specified Workbook as a  OOXML format (Excel 2007 or later) .xlsx or&nbs= p; BIFF8 format (Excel 97 or later) .xls file.

Save(Workbook, System.IO.Stream)

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

Save(Workbook, System.Web.HttpResponse, String, Boolean)

Streams the specified workbook to the client. It= should be the only method that uses the response object, as it automatical= ly sets response headers, clears the body of the response, and flushes it t= o the client.

Save(Workbook, System.Web.HttpResponse, String, Boolean, String)=

Streams the specified workbook to the client. It= should be the only method that uses the response object, as it automatical= ly sets response headers, clears the body of the response, and flushes it t= o the client.

SaveToStream(Workbook)

Saves a specified Workbook object to a Syst= em.IO.Stream object and returns it.

Nested Classes

Name

Description

FileFormat

When creating Excel files with Cr= eate, specifies which file format to use.
=20

Extension Methods

Overload

Description

Open(Microsoft.SharePoint.SPDocumentLibrary, String)

Opens an existing Excel spreadsheet from a Share= Point Document Library.

Open(Microsoft.SharePoint.SPListItem, String)

Opens an existing Excel spreadsheet that is atta= ched to a SharePoint List Item.

Save(Workbook, Microsoft.SharePoint.SPDocumentLibrary, String, Boole= an)

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

Save(Workbook, Microsoft.SharePoint.SPListItem, String)

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