Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Description

Excerpt

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.

Signature
C#
C#
  public class ExcelApplication
Signature
vb.net
vb.net

Public Class ExcelApplication
Remarks

A generated workbook is represented by the Workbook class.

To create an instance of ExcelApplication:

In C#:

  • Import ExcelApplication to the C# page:

    Code Block
    csharp
    csharp
    
    using SoftArtisans.OfficeWriter.ExcelWriter;
  • Create an ExcelApplication object:

    Code Block
    csharp
    csharp
    
    ExcelApplication xla = new ExcelApplication();

In VB.NET:

  • Import ExcelApplication to the VB.NET page:

    Code Block
    vbnet
    vbnet
    Imports SoftArtisans.OfficeWriter.ExcelWriter
  • Create an ExcelApplication object:

    {

    Code Block
    :
    vbnet
    }
    vbnet
    Dim xla As New ExcelApplication()
    Code Block

Properties

Name

Description

LicenseKey

Excerpt Include
EW8:ExcelApplication.LicenseKeyEW8:
ExcelApplication.LicenseKey
nopaneltrue

Version

Excerpt Include
EW8:ExcelApplication.VersionEW8:
ExcelApplication.Version
nopaneltrue

Methods

Name

Description

Create(FileFormat)

Excerpt Include
EW8:ExcelApplication.Create(FileFormat)EW8:
ExcelApplication.Create(FileFormat)
nopaneltrue

ExcelApplication()

Excerpt Include
EW8:ExcelApplication.ExcelApplication()EW8:
ExcelApplication.ExcelApplication()
nopaneltrue

Open(ExcelTemplate)

Excerpt Include
EW8:ExcelApplication.Open(ExcelTemplate)EW8:
ExcelApplication.Open(ExcelTemplate)
nopaneltrue

Open(String)

Excerpt Include
EW8:ExcelApplication.Open(String)EW8:
ExcelApplication.Open(String)
nopaneltrue

Open(String, String)

Excerpt Include
EW8:ExcelApplication.Open(String, String)EW8:
ExcelApplication.Open(String, String)
nopaneltrue

Open(System.IO.Stream)

Excerpt Include
EW8:ExcelApplication.Open(System.IO.Stream)EW8:
ExcelApplication.Open(System.IO.Stream)
nopaneltrue

Open(System.IO.Stream, String)

Excerpt Include
EW8:ExcelApplication.Open(System.IO.Stream, String)EW8:
ExcelApplication.Open(System.IO.Stream, String)
nopaneltrue

Save(Workbook, String)

Excerpt Include
EW8:ExcelApplication.Save(Workbook, String)EW8:
ExcelApplication.Save(Workbook, String)
nopaneltrue

Save(Workbook, System.IO.Stream)

Excerpt Include
EW8:ExcelApplication.Save(Workbook, System.IO.Stream)EW8:
ExcelApplication.Save(Workbook, System.IO.Stream)
nopaneltrue

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

Excerpt Include
EW8:ExcelApplication.Save(Workbook, System.Web.HttpResponse, String, Boolean)EW8:
ExcelApplication.Save(Workbook, System.Web.HttpResponse, String, Boolean)
nopaneltrue

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

Excerpt Include
EW8:ExcelApplication.Save(Workbook, System.Web.HttpResponse, String, Boolean, String)EW8:
ExcelApplication.Save(Workbook, System.Web.HttpResponse, String, Boolean, String)
nopaneltrue

SaveToStream(Workbook)

Excerpt Include
ExcelApplication.SaveToStream(Workbook)
ExcelApplication.SaveToStream(Workbook)
nopaneltrue

Classes

Name

Description

FileFormat

Excerpt Include
ExcelApplication.FileFormat
ExcelApplication.FileFormat
nopaneltrue

Extensionmethods
Introducedin
7.5
7.5

Overload

Description

Open(Microsoft.SharePoint.SPDocumentLibrary, String)

Excerpt Include
EW8:SharePointIntegration.Open(ExcelApplication, Microsoft.SharePoint.SPDocumentLibrary, String)EW8:
SharePointIntegration.Open(ExcelApplication, Microsoft.SharePoint.SPDocumentLibrary, String)
nopaneltrue

Open(Microsoft.SharePoint.SPListItem, String)

Excerpt Include
EW8:SharePointIntegration.Open(ExcelApplication, Microsoft.SharePoint.SPListItem, String)EW8:
SharePointIntegration.Open(ExcelApplication, Microsoft.SharePoint.SPListItem, String)
nopaneltrue

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

Excerpt Include
EW8:SharePointIntegration.Save(ExcelApplication, Workbook, Microsoft.SharePoint.SPDocumentLibrary, String, Boolean)EW8:
SharePointIntegration.Save(ExcelApplication, Workbook, Microsoft.SharePoint.SPDocumentLibrary, String, Boolean)
nopaneltrue

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

Excerpt Include
EW8:SharePointIntegration.Save(ExcelApplication, Workbook, Microsoft.SharePoint.SPListItem, String)EW8:
SharePointIntegration.Save(ExcelApplication, Workbook, Microsoft.SharePoint.SPListItem, String)
nopaneltrue