OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 10

changes.mady.by.user Unknown User (kylem)

Saved on

compared with

New Version Current

changes.mady.by.user Wiki Administrator

Saved on

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}{signature:
}
Signature
vb.net
vb.net
Public Class ExcelApplication
{signature}
{remarks}A generated workbook is represented by the [Workbook|Workbook] class.

To create an instance of {{ExcelApplication}}:

In C\#:

* Import {{ExcelApplication}} to the C\# page: {code:csharp}
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;
{code} * Create an {{ExcelApplication}} object: {code:csharp} 
  • Create an ExcelApplication object:
     Code Block
    csharp
    csharp
    ExcelApplication xla = new ExcelApplication();
{code}



In 
In VB.NET:


* Import {{ExcelApplication}} to the 
  • Import ExcelApplication to the VB.NET 
 
  •  page:

{
  •  Code Block
:
  • vbnet
}
  • vbnet
    Imports SoftArtisans.OfficeWriter.ExcelWriter
{code}

* Create an {{ExcelApplication}} object: \{code:vbnet}
  • Create an ExcelApplication object:
     Code Block
    vbnet
    vbnet
    Dim xla As New ExcelApplication()
{code}


{remarks}
{properties}
||Name||Description||
|[LicenseKey|ExcelApplication.LicenseKey]|{excerpt-include:ExcelApplication.LicenseKey|nopanel=true}|
|[Version|ExcelApplication.Version]|{excerpt-include:ExcelApplication.Version|nopanel=true}|
{methods}
||Name||Description||
|[Create()|ExcelApplication.Create()]|{excerpt-include:ExcelApplication.Create()|nopanel=true}|
|[Create(FileFormat)|ExcelApplication.Create(FileFormat)]|{excerpt-include:ExcelApplication.Create(FileFormat)|nopanel=true}|
|[ExcelApplication()|ExcelApplication.ExcelApplication()]|{excerpt-include:ExcelApplication.ExcelApplication()|nopanel=true}|
|[Open(ExcelTemplate)|ExcelApplication.Open(ExcelTemplate)]|{excerpt-include:
 Properties
Name
Description
LicenseKey
 Excerpt Include
ExcelApplication.LicenseKey
ExcelApplication.LicenseKey
nopaneltrue
Version
 Excerpt Include
ExcelApplication.Version
ExcelApplication.Version
nopaneltrue
 Methods
Name
Description
Create(FileFormat)
 Excerpt Include
ExcelApplication.Create(FileFormat)
ExcelApplication.Create(FileFormat)
nopaneltrue
ExcelApplication()
 Excerpt Include
ExcelApplication.ExcelApplication()
ExcelApplication.ExcelApplication()
nopaneltrue
Open(ExcelTemplate)
 Excerpt Include
ExcelApplication.Open(ExcelTemplate)
ExcelApplication.Open(ExcelTemplate)
...
nopanel
...
true
Open(String)
...
 Excerpt Include
ExcelApplication.Open(String)
...
ExcelApplication.Open(String)
...
nopanel
...
true
Open(String, 
...
 String)
...
 Excerpt Include
ExcelApplication.Open(String, 
...
 String)
...
ExcelApplication.Open(String, 
...
 String)
...
nopanel
...
true
Open(System.IO.Stream)
...
 Excerpt Include
ExcelApplication.Open(System.IO.Stream)
...
ExcelApplication.Open(System.IO.Stream)
...
nopanel
...
true
Open(System.IO.Stream, 
...
 String)
...
 Excerpt Include
ExcelApplication.Open(System.IO.Stream, 
...
 String)
...
ExcelApplication.Open(System.IO.Stream, 
...
 String)
...
nopanel
...
true
Save(Workbook, 
...
 String)
...
 Excerpt Include
ExcelApplication.Save(Workbook, 
...
 String)
...
ExcelApplication.Save(Workbook, 
...
 String)
...
nopanel
...
true
Save(Workbook, 
...
 System.IO.Stream)
...
 Excerpt Include
ExcelApplication.Save(Workbook, 
...
 System.IO.Stream)
...
ExcelApplication.Save(Workbook, 
...
 System.IO.Stream)
...
nopanel
...
true
Save(Workbook, 
...
 System.Web.HttpResponse, 
...
 String, 
...
 Boolean)
...
 Excerpt Include
ExcelApplication.Save(Workbook, 
...
 System.Web.HttpResponse, 
...
 String, 
...
 Boolean)
...
ExcelApplication.Save(Workbook, 
...
 System.Web.HttpResponse, 
...
 String, 
...
 Boolean)
...
nopanel
...
true
Save(Workbook, 
...
 System.Web.HttpResponse, 
...
 String, 
...
 Boolean, 
...
 String)
...
 Excerpt Include
ExcelApplication.Save(Workbook, 
...
 System.Web.HttpResponse, 
...
 String, 
...
 Boolean, 
...
 String)
...
ExcelApplication.Save(Workbook, 
...
 System.Web.HttpResponse, 
...
 String, 
...
 Boolean, 
...
 String)
...
nopanel
...
true
SaveToStream(Workbook)
...
 Excerpt Include
ExcelApplication.SaveToStream(Workbook)
...
ExcelApplication.SaveToStream(Workbook)
...
nopanel
...
true
 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
SharePointIntegration.Open(ExcelApplication, 
...
 Microsoft.SharePoint.SPDocumentLibrary, 
...
 String)
...
SharePointIntegration.Open(ExcelApplication, 
...
 Microsoft.SharePoint.SPDocumentLibrary, 
...
 String)
...
nopanel
...
true
Open(Microsoft.SharePoint.SPListItem, 
...
 String)
...
 Excerpt Include
SharePointIntegration.Open(ExcelApplication, 
...
 Microsoft.SharePoint.SPListItem, 
...
 String)
...
SharePointIntegration.Open(ExcelApplication, 
...
 Microsoft.SharePoint.SPListItem, 
...
 String)
...
nopanel
...
true
Save(Workbook, 
...
 Microsoft.SharePoint.SPDocumentLibrary, 
...
 String, 
...
 Boolean)
...
 Excerpt Include
SharePointIntegration.Save(ExcelApplication, 
...
 Workbook, 
...
 Microsoft.SharePoint.SPDocumentLibrary, 
...
 String, 
...
 Boolean)
...
SharePointIntegration.Save(ExcelApplication, 
...
 Workbook, 
...
 Microsoft.SharePoint.SPDocumentLibrary, 
...
 String, 
...
 Boolean)
...
nopanel
...
true
Save(Workbook, 
...
 Microsoft.SharePoint.SPListItem, 
...
 String)
...
 Excerpt Include
SharePointIntegration.Save(ExcelApplication, 
...
 Workbook, 
...
 Microsoft.SharePoint.SPListItem, 
...
 String)
...
SharePointIntegration.Save(ExcelApplication, 
...
 Workbook, 
...
 Microsoft.SharePoint.SPListItem, 
...
 String)
...
nopanel
...
true
...