Page History

Description

Excerpt
The Process method enters data source values in a template's data markers, and creates the output file (the new spreadsheet) in memory. The Save method can then save the output file to disk, stream it to the browser, or both.

Signature

	C#
	C#

  public virtual void Process()

Signature

	vb.net
	vb.net


Public Overridable Sub Process()

Remarks

Call Process after SetDataSource BindData and before Save.

You can call Process only once for each instance of ExcelTemplate.

Example

Code Block

	csharp
	csharp
title	C#

            ExcelTemplate xlt = new ExcelTemplate();
          xlt.Open(Application["templatepath"] +
               @"\DataBinding\ArrayBindingTemplate2.xls");

          //--- Set a data source for the data marker "SimpleArray."
          string[] onedim = {"SoftArtisans", "OfficeWriter", "ExcelTemplate"};
          xlt.SetColumnDataSource(onedim, "SimpleArray");

          //--- Process the template to populate it with the data source data.
          xlt.Process();

          //--- Stream the processed document to the client.
          xlt.Save(Page.Response, "ArrayBinding.xls", false);

Code Block

	vb.net
	vb.net
title	vb.net

            Dim xlt As New ExcelTemplate()
          xlt.Open(Application("templatepath") & _
               "\DataBinding\ArrayBindingTemplate2.xls")

          '--- Set a data source for the data marker "SimpleArray."
          Dim onedim As String() = {"SoftArtisans", "OfficeWriter", "ExcelTemplate"}
          xlt.SetColumnDataSource(onedim, "SimpleArray")

          '--- Process the template to populate it with the data source data.
          xlt.Process()

          '--- Stream the processed document to the client.
          xlt.Save(Page.Response, "ArrayBinding.xls", False)

Space Shortcuts

Page tree

Versions Compared

Old Version 7

New Version Current

Key