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.

 public virtual void Process()
Public Overridable Sub Process()

Call Process after BindData and before Save.

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

          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);
       
          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)