Page tree

Versions Compared

Key

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

Description

Excerpt

The ExcelTemplate object represents an ExcelWriter template spreadsheet.

Signature
C#
C#

public class ExcelTemplate
Signature
vb.net
vb.net

Public Class ExcelTemplate

...

Example

If you are coding directly in the .aspx page, following the Page directive, include:

Code Block

<%@ Import Namespace="SoftArtisans.OfficeWriter.ExcelWriter" %>

If you are coding in the "code behind" page (.aspx.vb or .aspx.cs), include an Imports or using statement at the top of the "code behind" page:

Code Block
csharp
csharp
titleC#

using SoftArtisans.OfficeWriter.ExcelWriter;
Code Block
vb.net
vb.net
titlevb.net

Imports SoftArtisans.OfficeWriter.ExcelWriter

To create an instance of the ExcelTemplate object use:

Code Block
csharp
csharp
titleC#

ExcelTemplate oExcelTemplate = new ExcelTemplate();
Code Block
vb.net
vb.net
titlevb.net

Dim oExcelTemplate As New ExcelTemplate()

Fields

ALL_ROWS

Excerpt Include
ExcelTemplate.ALL_ROWS
ExcelTemplate.ALL_ROWS
nopaneltrue

Properties

Name

Description

ContentType

Excerpt Include
ExcelTemplate.ContentType
ExcelTemplate.ContentType
nopaneltrue

DecryptPassword

Excerpt Include
ExcelTemplate.DecryptPassword
ExcelTemplate.DecryptPassword
nopaneltrue

EncryptPassword

Excerpt Include
ExcelTemplate.EncryptPassword
ExcelTemplate.EncryptPassword
nopaneltrue

ExcludeMacros

Excerpt Include
ExcelTemplate.ExcludeMacros
ExcelTemplate.ExcludeMacros
nopaneltrue

LicenseKey

Excerpt Include
ExcelTemplate.LicenseKey
ExcelTemplate.LicenseKey
nopaneltrue

PreserveStrings

Excerpt Include
ExcelTemplate.PreserveStrings
ExcelTemplate.PreserveStrings
nopaneltrue

RemoveExtraDataMarkers

Excerpt Include
ExcelTemplate.RemoveExtraDataMarkers
ExcelTemplate.RemoveExtraDataMarkers
nopaneltrue

StretchCellReferencesInCharts

Excerpt Include
ExcelTemplate.StretchCellReferencesInCharts
ExcelTemplate.StretchCellReferencesInCharts
nopaneltrue

Version

Excerpt Include
ExcelTemplate.Version
ExcelTemplate.Version
nopaneltrue

Methods

Name

Description

BindCellData(Object, String, DataBindingProperties)

Excerpt Include
ExcelTemplate.BindCellData(Object, String, DataBindingProperties)
ExcelTemplate.BindCellData(Object, String, DataBindingProperties)
nopaneltrue

BindColumnData(Object(), String, DataBindingProperties)

Excerpt Include
ExcelTemplate.BindColumnData(Object(), String, DataBindingProperties)
ExcelTemplate.BindColumnData(Object(), String, DataBindingProperties)
nopaneltrue

BindColumnData(System.Collections.IDictionary, String, DataBindingProperties)

Excerpt Include
ExcelTemplate.BindColumnData(System.Collections.IDictionary, String, DataBindingProperties)
ExcelTemplate.BindColumnData(System.Collections.IDictionary, String, DataBindingProperties)
nopaneltrue

BindColumnData(System.Collections.IEnumerable, String, DataBindingProperties)

Excerpt Include
ExcelTemplate.BindColumnData(System.Collections.IEnumerable, String, DataBindingProperties)
ExcelTemplate.BindColumnData(System.Collections.IEnumerable, String, DataBindingProperties)
nopaneltrue

BindData(Object()(), String(), String, DataBindingProperties)

Excerpt Include
ExcelTemplate.BindData(Object()(), String(), String, DataBindingProperties)
ExcelTemplate.BindData(Object()(), String(), String, DataBindingProperties)
nopaneltrue

BindData(Object(,), String(), String, DataBindingProperties)

Excerpt Include
ExcelTemplate.BindData(Object(,), String(), String, DataBindingProperties)
ExcelTemplate.BindData(Object(,), String(), String, DataBindingProperties)
nopaneltrue

BindData(System.Data.IDataReader, String, DataBindingProperties)

Excerpt Include
ExcelTemplate.BindData(System.Data.IDataReader, String, DataBindingProperties)
ExcelTemplate.BindData(System.Data.IDataReader, String, DataBindingProperties)
nopaneltrue

BindData(System.Data.DataSet, String, DataBindingProperties)

Excerpt Include
ExcelTemplate.BindData(System.Data.DataSet, String, DataBindingProperties)
ExcelTemplate.BindData(System.Data.DataSet, String, DataBindingProperties)
nopaneltrue

BindData(System.Data.DataTable, String, DataBindingProperties)

Excerpt Include
ExcelTemplate.BindData(System.Data.DataTable, String, DataBindingProperties)
ExcelTemplate.BindData(System.Data.DataTable, String, DataBindingProperties)
nopaneltrue

BindRowData(Object(), String(), String, DataBindingProperties)

Excerpt Include
ExcelTemplate.BindRowData(Object(), String(), String, DataBindingProperties)
ExcelTemplate.BindRowData(Object(), String(), String, DataBindingProperties)
nopaneltrue

BindRowData(System.Collections.IDictionary, String, DataBindingProperties)

Excerpt Include
ExcelTemplate.BindRowData(System.Collections.IDictionary, String, DataBindingProperties)
ExcelTemplate.BindRowData(System.Collections.IDictionary, String, DataBindingProperties)
nopaneltrue

BindRowData(System.Collections.IEnumerable, String(), String, DataBindingProperties)

Excerpt Include
ExcelTemplate.BindRowData(System.Collections.IEnumerable, String(), String, DataBindingProperties)
ExcelTemplate.BindRowData(System.Collections.IEnumerable, String(), String, DataBindingProperties)
nopaneltrue

BindRowData(System.Data.DataSet, String, DataBindingProperties)

Excerpt Include
ExcelTemplate.BindRowData(System.Data.DataSet, String, DataBindingProperties)
ExcelTemplate.BindRowData(System.Data.DataSet, String, DataBindingProperties)
nopaneltrue

BindRowData(System.Data.DataTable, String, DataBindingProperties)

Excerpt Include
ExcelTemplate.BindRowData(System.Data.DataTable, String, DataBindingProperties)
ExcelTemplate.BindRowData(System.Data.DataTable, String, DataBindingProperties)
nopaneltrue

BindRowData(System.Data.DataView, String, DataBindingProperties)

Excerpt Include
ExcelTemplate.BindRowData(System.Data.DataView, String, DataBindingProperties)
ExcelTemplate.BindRowData(System.Data.DataView, String, DataBindingProperties)
nopaneltrue

CreateDataBindingProperties()

Excerpt Include
ExcelTemplate.CreateDataBindingProperties()
ExcelTemplate.CreateDataBindingProperties()
nopaneltrue

ExcelTemplate()

Excerpt Include
ExcelTemplate.ExcelTemplate()
ExcelTemplate.ExcelTemplate()
nopaneltrue

Open(ExcelApplication, Workbook)

Excerpt Include
ExcelTemplate.Open(ExcelApplication, Workbook)
ExcelTemplate.Open(ExcelApplication, Workbook)
nopaneltrue

Open(String)

Excerpt Include
ExcelTemplate.Open(String)
ExcelTemplate.Open(String)
nopaneltrue

Open(System.IO.Stream)

Excerpt Include
ExcelTemplate.Open(System.IO.Stream)
ExcelTemplate.Open(System.IO.Stream)
nopaneltrue

Process()

Excerpt Include
ExcelTemplate.Process()
ExcelTemplate.Process()
nopaneltrue

Save(String)

Excerpt Include
ExcelTemplate.Save(String)
ExcelTemplate.Save(String)
nopaneltrue

Save(System.IO.Stream)

Excerpt Include
ExcelTemplate.Save(System.IO.Stream)
ExcelTemplate.Save(System.IO.Stream)
nopaneltrue

Save(System.Web.HttpResponse)

Excerpt Include
ExcelTemplate.Save(System.Web.HttpResponse)
ExcelTemplate.Save(System.Web.HttpResponse)
nopaneltrue

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

Excerpt Include
ExcelTemplate.Save(System.Web.HttpResponse, String, Boolean)
ExcelTemplate.Save(System.Web.HttpResponse, String, Boolean)
nopaneltrue

SetCellDataSource(Object, String)

Excerpt Include
ExcelTemplate.SetCellDataSource(Object, String)
ExcelTemplate.SetCellDataSource(Object, String)
nopaneltrue

SetColumnDataSource(Object(), String)

Excerpt Include
ExcelTemplate.SetColumnDataSource(Object(), String)
ExcelTemplate.SetColumnDataSource(Object(), String)
nopaneltrue

SetColumnDataSource(Object(), String, Int32)

Excerpt Include
ExcelTemplate.SetColumnDataSource(Object(), String, Int32)
ExcelTemplate.SetColumnDataSource(Object(), String, Int32)
nopaneltrue

SetColumnDataSource(System.Collections.IDictionary, String)

Excerpt Include
ExcelTemplate.SetColumnDataSource(System.Collections.IDictionary, String)
ExcelTemplate.SetColumnDataSource(System.Collections.IDictionary, String)
nopaneltrue

SetColumnDataSource(System.Collections.IDictionary, String, Int32)

Excerpt Include
ExcelTemplate.SetColumnDataSource(System.Collections.IDictionary, String, Int32)
ExcelTemplate.SetColumnDataSource(System.Collections.IDictionary, String, Int32)
nopaneltrue

SetColumnDataSource(System.Collections.IEnumerable, String)

Excerpt Include
ExcelTemplate.SetColumnDataSource(System.Collections.IEnumerable, String)
ExcelTemplate.SetColumnDataSource(System.Collections.IEnumerable, String)
nopaneltrue

SetColumnDataSource(System.Collections.IEnumerable, String, Int32)

Excerpt Include
ExcelTemplate.SetColumnDataSource(System.Collections.IEnumerable, String, Int32)
ExcelTemplate.SetColumnDataSource(System.Collections.IEnumerable, String, Int32)
nopaneltrue

SetDataSource(Object()(), String(), String)

Excerpt Include
ExcelTemplate.SetDataSource(Object()(), String(), String)
ExcelTemplate.SetDataSource(Object()(), String(), String)
nopaneltrue

SetDataSource(Object()(), String(), String, Int32, Boolean)

Excerpt Include
ExcelTemplate.SetDataSource(Object()(), String(), String, Int32, Boolean)
ExcelTemplate.SetDataSource(Object()(), String(), String, Int32, Boolean)
nopaneltrue

SetDataSource(Object(,), String(), String)

Excerpt Include
ExcelTemplate.SetDataSource(Object(,), String(), String)
ExcelTemplate.SetDataSource(Object(,), String(), String)
nopaneltrue

SetDataSource(Object(,), String(), String, Int32, Boolean)

Excerpt Include
ExcelTemplate.SetDataSource(Object(,), String(), String, Int32, Boolean)
ExcelTemplate.SetDataSource(Object(,), String(), String, Int32, Boolean)
nopaneltrue

SetDataSource(System.Data.IDataReader, String)

Excerpt Include
ExcelTemplate.SetDataSource(System.Data.IDataReader, String)
ExcelTemplate.SetDataSource(System.Data.IDataReader, String)
nopaneltrue

SetDataSource(System.Data.IDataReader, String, Int32)

Excerpt Include
ExcelTemplate.SetDataSource(System.Data.IDataReader, String, Int32)
ExcelTemplate.SetDataSource(System.Data.IDataReader, String, Int32)
nopaneltrue

SetDataSource(System.Data.DataSet, String)

Excerpt Include
ExcelTemplate.SetDataSource(System.Data.DataSet, String)
ExcelTemplate.SetDataSource(System.Data.DataSet, String)
nopaneltrue

SetDataSource(System.Data.DataSet, String, Int32)

Excerpt Include
ExcelTemplate.SetDataSource(System.Data.DataSet, String, Int32)
ExcelTemplate.SetDataSource(System.Data.DataSet, String, Int32)
nopaneltrue

SetDataSource(System.Data.DataTable, String)

Excerpt Include
ExcelTemplate.SetDataSource(System.Data.DataTable, String)
ExcelTemplate.SetDataSource(System.Data.DataTable, String)
nopaneltrue

SetDataSource(System.Data.DataTable, String, Int32)

Excerpt Include
ExcelTemplate.SetDataSource(System.Data.DataTable, String, Int32)
ExcelTemplate.SetDataSource(System.Data.DataTable, String, Int32)
nopaneltrue

SetRowDataSource(Object(), String(), String)

Excerpt Include
ExcelTemplate.SetRowDataSource(Object(), String(), String)
ExcelTemplate.SetRowDataSource(Object(), String(), String)
nopaneltrue

SetRowDataSource(System.Collections.IDictionary, String)

Excerpt Include
ExcelTemplate.SetRowDataSource(System.Collections.IDictionary, String)
ExcelTemplate.SetRowDataSource(System.Collections.IDictionary, String)
nopaneltrue

SetRowDataSource(System.Collections.IEnumerable, String(), String)

Excerpt Include
ExcelTemplate.SetRowDataSource(System.Collections.IEnumerable, String(), String)
ExcelTemplate.SetRowDataSource(System.Collections.IEnumerable, String(), String)
nopaneltrue

SetRowDataSource(System.Data.DataSet, String)

Excerpt Include
ExcelTemplate.SetRowDataSource(System.Data.DataSet, String)
ExcelTemplate.SetRowDataSource(System.Data.DataSet, String)
nopaneltrue

SetRowDataSource(System.Data.DataTable, String)

Excerpt Include
ExcelTemplate.SetRowDataSource(System.Data.DataTable, String)
ExcelTemplate.SetRowDataSource(System.Data.DataTable, String)
nopaneltrue

SetRowDataSource(System.Data.DataView, String)

Excerpt Include
ExcelTemplate.SetRowDataSource(System.Data.DataView, String)
ExcelTemplate.SetRowDataSource(System.Data.DataView, String)
nopaneltrue
Extensionmethods
Introducedin
7.57.5

Name

Description

BindData(Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, String, DataBindingProperties)

Excerpt Include
SharePointIntegration.BindData(ExcelTemplate, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, String, DataBindingProperties)
SharePointIntegration.BindData(ExcelTemplate, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, String, DataBindingProperties)
nopaneltrue

BindData(Microsoft.SharePoint.SPList, String, DataBindingProperties)

Excerpt Include
SharePointIntegration.BindData(ExcelTemplate, Microsoft.SharePoint.SPList, String, DataBindingProperties)
SharePointIntegration.BindData(ExcelTemplate, Microsoft.SharePoint.SPList, String, DataBindingProperties)
nopaneltrue

BindRowData(Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, String, DataBindingProperties)

Excerpt Include
SharePointIntegration.BindRowData(ExcelTemplate, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, String, DataBindingProperties)
SharePointIntegration.BindRowData(ExcelTemplate, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, String, DataBindingProperties)
nopaneltrue

BindRowData(Microsoft.SharePoint.SPList, String, DataBindingProperties)

Excerpt Include
SharePointIntegration.BindRowData(ExcelTemplate, Microsoft.SharePoint.SPList, String, DataBindingProperties)
SharePointIntegration.BindRowData(ExcelTemplate, Microsoft.SharePoint.SPList, String, DataBindingProperties)
nopaneltrue

Open(Microsoft.SharePoint.SPDocumentLibrary, String)

Excerpt Include
SharePointIntegration.Open(ExcelTemplate, Microsoft.SharePoint.SPDocumentLibrary, String)
SharePointIntegration.Open(ExcelTemplate, Microsoft.SharePoint.SPDocumentLibrary, String)
nopaneltrue

Open(Microsoft.SharePoint.SPListItem, String)

Excerpt Include
SharePointIntegration.Open(ExcelTemplate, Microsoft.SharePoint.SPListItem, String)
SharePointIntegration.Open(ExcelTemplate, Microsoft.SharePoint.SPListItem, String)
nopaneltrue

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

Excerpt Include
SharePointIntegration.Save(ExcelTemplate, Microsoft.SharePoint.SPDocumentLibrary, String, Boolean)
SharePointIntegration.Save(ExcelTemplate, Microsoft.SharePoint.SPDocumentLibrary, String, Boolean)
nopaneltrue

Save(Microsoft.SharePoint.SPListItem, String)

Excerpt Include
SharePointIntegration.Save(ExcelTemplate, Microsoft.SharePoint.SPListItem, String)
SharePointIntegration.Save(ExcelTemplate, Microsoft.SharePoint.SPListItem, String)
nopaneltrue