//Use ExcelTemplate to bind data for each selected country
//to worksheets in the template, then populate the report
//with that data
protected void PopulateTemplate()
{
            
}

xlt.RemoveExtraDataMarkers = true;

DataBindingProperties dataBindProps;

for (int i = 0; i < wbselectedCountries.Worksheets.Count; i++)
{

    BindCountryData(wb.Worksheets[i].Name);
}

string country = selectedCountries[i];

dataBindProps = xlt.CreateDataBindingProperties();

dataBindProps.WorksheetName = country;

In the sample project, we are parsing CSV files with query results, rather than querying a live database. The CSV files are available under the data directory. There is a copy of the CSV parser, GenericParsing.dll in the bin directory of the project GetCSVData is defined in Part1.aspx.cs in a region marked Utility Methods.

DataTable dts = GetCSVData(Page.MapPath("//data//" + country + "5.csv"));
DataTable dts2 = GetCSVData(Page.MapPath("//data//" + country + "All.csv"));

for (int i = 0; i < selectedCountries.Count; i++)
    {
    string country    wb.Worksheets.CopySheet(wb.Worksheets[0], wb.Worksheets.Count, = selectedCountries[i]);

   } 
    wb.Worksheets[0].Visibility = Worksheet.SheetVisibility.Hidden;
    wb.Worksheets[1].Select();

    xlt = new ExcelTemplate();
    xlt.Open(xla, wb);

    for (int i = 0; i < wb.Worksheets.Count; i++)
    {
          BindCountryData(wb.Worksheets[i].Name);
    }

    xlt.Process();
    xlt.Save(Page.Response, "output.xlsx", false);
}

protected void BindCountryData(string selection)
        {
            DataBindingProperties dbp = xlt.dataBindProps = xlt.CreateDataBindingProperties();

           dbpdataBindProps.WorksheetName = selectioncountry;

            string[] specificInfoheaderValues = { "FY 2008", "Foreign Trade Division", selectioncountry };
             string[] headerTitlesheaderNames = { "FiscalYear", "TradeDivision", "Country" };

            xlt.BindRowData(specificInfoheaderValues, headerTitlesheaderNames, "Header", dbpdataBindProps);

            DataTable dts = Sales(selection, "TOP 5")GetCSVData(Page.MapPath("//data//" + country + "5.csv"));
            DataTable dts2 = Sales(selection, "");
   GetCSVData(Page.MapPath("//data//" + country + "All.csv"));

       xlt.BindData(dts, "Top", dbpdataBindProps);
            xlt.BindData(dts2, "Details", dbpdataBindProps);
        }

public static DataTable Sales(string selection, string topORall)
  }

xlt.Process();

xlt.Save(Page.Response, "output.xlsx", false);

protected void PopulateTemplate()
{
     {       xlt = new     ExcelTemplate(); //Create thea querynew ExcelTemplate object

         string queryString = "USE AdventureWorks2008R2 xlt.Open(xla, wb);
"
+            xlt.RemoveExtraDataMarkers     "DECLARE @find nvarchar(100)= true;
"
+                 "SET @find ='" + selection + "'; " +DataBindingProperties dataBindProps;

            for (int i = 0; "SELECTi " + topORall + " Sales.Store.Name AS Description, Sales.SalesOrderHeader.TotalDue AS Sales FROM Sales.Store " +< selectedCountries.Count; i++)
            {
   "INNER JOIN Sales.Customer ON Sales.Store.BusinessEntityID = Sales.Customer.StoreID " +     string            "INNER JOIN Sales.SalesOrderHeader ON Sales.Customer.CustomerID = Sales.SalesOrderHeader.CustomerID " +country = selectedCountries[i];

                 "INNER JOIN Sales.SalesTerritory ON Sales.SalesTerritory.TerritoryID = Sales.Customer.TerritoryID " +dataBindProps = xlt.CreateDataBindingProperties();

                 "WHERE DATEPART(yyyy, Sales.SalesOrderHeader.OrderDate)dataBindProps.WorksheetName = 2008country;
"
+                string[] "AND Sales.SalesOrderHeader.OnlineOrderFlag headerValues = 0{ " +
                "AND Sales.SalesTerritory.Name = @find " +
                "ORDER BY Sales DESC;";FY 2008", "Foreign Trade Division", country };
             //Get connection  string[]           SqlConnection connection headerNames = new{ SqlConnection(@"Data Source=TS-IH03\SQL2008R2;Initial Catalog=ExcelApp2;Integrated Security=True")"FiscalYear", "TradeDivision", "Country" };

            //Assign command and associated connection
            SqlCommand cmd = new SqlCommand(queryString, connection xlt.BindRowData(headerValues, headerNames, "Header", dataBindProps);

            //Select data adapter  DataTable           SqlDataAdapter adapter = new SqlDataAdapter();
            adapter.SelectCommand = cmd;

            //Make a new table, fill it and return itdts = GetCSVData(Page.MapPath("//data//" + country + "5.csv"));
                DataTable dtGetdts2 = new DataTable();
            adapter.Fill(dtGet)GetCSVData(Page.MapPath("//data//" + country + "All.csv"));

           return dtGet;         }


protected List<string> GetListBoxSelections(){
        //Get the ListBox selections and make the appropriate number of copies
            List<string> countryNames = new List<string>(xlt.BindData(dts, "Top", dataBindProps);
            foreach (int i in ListBox1xlt.GetSelectedIndicesBindData())
 dts2, "Details", dataBindProps);
          {  }
              countryNamesxlt.Add(ListBox1.Items[i].TextProcess();
            }
            return countryNames;
        }
xlt.Save(Page.Response, "Output.xlsx", false);
}