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:vbnet}Dim xla As New ExcelApplication()
    Code Block
Properties

Name

Description

LicenseKey

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

Version

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

Name

Description

Create()

Excerpt Include
EW8:ExcelApplication.Create()
EW8:ExcelApplication.Create()
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
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