The ExcelTemplate object represents an ExcelWriter template spreadsheet.

public class ExcelTemplate
Public Class ExcelTemplate

An ExcelWriter template is a file created in Microsoft Excel that contains data markers.

A data marker specifies a database column, variable, or array to insert in the spreadsheet column containing the marker.

The ExcelTemplate object is in the SoftArtisans.OfficeWriter.ExcelWriter namespace. The object can be referenced as SoftArtisans.OfficeWriter.ExcelWriter.ExcelTemplate. To minimize typing and errors, use an Import directive to import the namespace to the aspx page, and reference the object as ExcelTemplate, without the namespace prefix.

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

<%@ 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:

using SoftArtisans.OfficeWriter.ExcelWriter;
Imports SoftArtisans.OfficeWriter.ExcelWriter

To create an instance of the ExcelTemplate object use:

ExcelTemplate oExcelTemplate = new ExcelTemplate();
Dim oExcelTemplate As New ExcelTemplate()

ALL_ROWS

Name

Description

ContentType

DecryptPassword

EncryptPassword

ExcludeMacros

LicenseKey

PreserveStrings

RemoveExtraDataMarkers

StretchCellReferencesInCharts

Version

Name

Description

BindCellData(Object, String, DataBindingProperties)

BindColumnData(Object(), String, DataBindingProperties)

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

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

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

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

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

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

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

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

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

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

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

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

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

CreateDataBindingProperties()

ExcelTemplate()

Open(ExcelApplication, Workbook)

Open(String)

Open(System.IO.Stream)

Process()

Save(String)

Save(System.IO.Stream)

Save(System.Web.HttpResponse)

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

SetCellDataSource(Object, String)

SetColumnDataSource(Object(), String)

SetColumnDataSource(Object(), String, Int32)

SetColumnDataSource(System.Collections.IDictionary, String)

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

SetColumnDataSource(System.Collections.IEnumerable, String)

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

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

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

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

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

SetDataSource(System.Data.IDataReader, String)

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

SetDataSource(System.Data.DataSet, String)

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

SetDataSource(System.Data.DataTable, String)

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

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

SetRowDataSource(System.Collections.IDictionary, String)

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

SetRowDataSource(System.Data.DataSet, String)

SetRowDataSource(System.Data.DataTable, String)

SetRowDataSource(System.Data.DataView, String)

Name

Description

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

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

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

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

Open(Microsoft.SharePoint.SPDocumentLibrary, String)

Open(Microsoft.SharePoint.SPListItem, String)

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

Save(Microsoft.SharePoint.SPListItem, String)