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
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
public class ExcelApplication=20
Public Class ExcelApplication=20
A generated workbook is represented by the Workbook class.
To create an instance of ExcelApplication
:
In C#:
Import ExcelApplication
to the C# page:
using SoftArtisans.OfficeWriter.ExcelWriter;=20
Create an ExcelApplication
object:
ExcelApplication xla =3D new ExcelApplication();=20
In VB.NET:
Import ExcelApplication
to the VB.NET page:
Imports SoftArtisans.OfficeWriter.ExcelWriter=20
Create an ExcelApplication
object:
Dim xla As New ExcelApplication()=20
Name |
Description |
---|---|
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. | |
Returns the exact version of ExcelWriter. The fo= rmat of the version string returned is: |
Name |
Description |
---|---|
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. |
|
Creates a new ExcelApplication object | |
Opens a Workbo= ok from an ExcelTemplate obj= ect. | |
Opens an existing Excel spreadsheet. | |
Opens an existing Excel spreadsheet. | |
Opens an Excel workbook from a stream and return= s a Workbook object. | |
Opens an Excel workbook from a stream and return= s a Workbook object. | |
Saves a specified Workbook as a OOXML format (Excel 2007 or later) .xlsx or&nbs= p; BIFF8 format (Excel 97 or later) .xls file. | |
Saves a specified Workbook as a BIFF8 format (Excel 97 or later).xls file. | |
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. |
Saves a specified Workbook object to a Syst= em.IO.Stream object and returns it. |
Name |
Description |
---|---|
When creating Excel files with Cr=
eate , specifies which file format to use. |
Overload |
Description |
---|---|
Opens an existing Excel spreadsheet from a Share= Point Document Library. | |
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. |
Saves a specified Workbook as a BIFF8 format (Excel 97 or later) .xls file. |