ExcelApplication is the main class for pure code-based workbook generation (for information about template-based workbook generation, see ExcelTemplate). This class is an engine used to open, create, and write (save or stream to a browser) workbooks. A single instance of ExcelApplication can generate multiple workbooks.

 public class ExcelApplication
Public Class ExcelApplication

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;
  • Create an ExcelApplication object:
    ExcelApplication xla = new ExcelApplication();

In VB.NET:

  • Import ExcelApplication to the VB.NET page:
    Imports SoftArtisans.OfficeWriter.ExcelWriter
  • Create an ExcelApplication object: {code:vbnet}Dim xla As New ExcelApplication()

Name

Description

LicenseKey

Version

Name

Description

Create()

ExcelApplication()

Open(ExcelTemplate)

Open(String)

Open(String, String)

Open(System.IO.Stream)

Open(System.IO.Stream, String)

Save(Workbook, String)

Save(Workbook, System.IO.Stream)

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

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

Overload

Description

Open(Microsoft.SharePoint.SPDocumentLibrary, String)

Open(Microsoft.SharePoint.SPListItem, String)

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

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