public void GenerateReport()

        {

            //Open the template file

            ExcelTemplate xlt = new ExcelTemplate();

            xlt.Open(@"..\..\templates\BindingPropertiesTemplate.xlsx");\
            //Get the data to bind to the template

            DataTable salesPeople = getSalesPeople();

            DataTable salesPeople2 = getSalesPeople();\
            //We will bind the data in two places, using the same data source name.

            //In the "Top 10" worksheet we will place the 10 sales people who have

            //earned the most money from sales this year

            DataBindingProperties topEmployeesProperties = xlt.CreateDataBindingProperties();

            topEmployeesProperties.MaxRows = 10;

            topEmployeesProperties.WorksheetName = "Top 10";\
            //In the "Employees" worksheet, we will place all sales people

            DataBindingProperties allEmployeesProperties = xlt.CreateDataBindingProperties();

            allEmployeesProperties.WorksheetName = "Employees";\
            //Bind the data to the template. While the same data object cannot be bound

            //in two different places, we can have data sources on two different worksheets

            //that have the same name, so long as we specify which worksheet we want to bind

            //to in the DataBindingProperties object.

            xlt.BindData(salesPeople, "SalesPerson", topEmployeesProperties);

            xlt.BindData(salesPeople2, "SalesPerson", allEmployeesProperties);\
            //Process the template, and save it.

            xlt.Process();

            xlt.Save(@"..\..\Output\BindingProperties_output.xlsx");

        }\
        private DataTable getSalesPeople()

        {

            //Table of sales people from the AdventureWorks database, along with their YTD sales

            DataTable dt = new DataTable();

            dt.Columns.Add("FirstName", typeof(string));

            dt.Columns.Add("LastName", typeof(string));

            dt.Columns.Add("SalesYTD", typeof(double));

            dt.Rows.Add("Linda", "Mitchell", 5200475.231);

            dt.Rows.Add("Jae", "Pak", 5015682.231);

            dt.Rows.Add("Michael", "Blythe", 4557045.0459);

            dt.Rows.Add("Jillian", "Carson", 3857163.6332);

            dt.Rows.Add("Ranjit", "Varkey Chudukatil", 3827950.238);

            dt.Rows.Add("David", "Campbell", 3587378.426);

            dt.Rows.Add("Jose", "Saraiva", 3189356.247);

            dt.Rows.Add("Shu", "Ito", 3018725.486);

            dt.Rows.Add("Tsvi", "Reiter", 2811012.715);

            dt.Rows.Add("Rachel", "Valdez", 2241204.042);

            dt.Rows.Add("Tete", "Mensa-Annan", 1931620.184);

            dt.Rows.Add("Garrett", "Vargas", 1764938.986);

            dt.Rows.Add("Lynn", "Tsoflias", 1758385.926);

            dt.Rows.Add("Stephen", "Jiang", 677558.4653);

            dt.Rows.Add("Amy", "Alberts", 636440.251);

            dt.Rows.Add("Syed", "Abbas", 219088.8836);

            dt.Rows.Add("Pamela", "Ansman-Wolfe", 0);

            return dt;

        }

    }\