public class DataMarkerOptions
    {
 
        /// <summary>
        /// Build the report with ExcelTemplate
        /// </summary>
        public void GenerateReport()
        {
            // This 2D Object[][] array will hold the values to be imported
              //employee ID
              //Last NamE
             //First Name
             //Title      
             //Zip     
    
object[,] values = {
{1, 2, 3, 4},
       {"Davolio", "Fuller", "Leverling", "Peacock"},
       {"Nancy", "Andrew", "Janet", "Margaret"},
{"Sales Rep", "VP of Sales", "Sales Rep", "Sales Rep"},
{"02139","02144","23451","00213"}
       };
 
            // These are the field names
            string[] colnames = { "EmployeeID", "LastName", "FirstName", "Title", "Zip" };
 
            // Create an instance of ExcelTemplate
            ExcelTemplate xlt = new ExcelTemplate();
 
            // Open the template workbook
            string templatePath = @"..\..\templates\DataMarkerOptionsTemplate.xlsx";
            xlt.Open(templatePath);
 
            // Pass colnames and values arrays to BindData()
            DataBindingProperties bindingProperties = xlt.CreateDataBindingProperties();
            bindingProperties.MaxRows = ExcelTemplate.ALL_ROWS;
            bindingProperties.Transpose = true;
            xlt.BindData(values, colnames, "dSource", bindingProperties);
 
            // Call the process() method to populate the template with the data source values
            xlt.Process();
 
            // Save the report
            xlt.Save(@"..\..\Output\DataMarkerOptions_output.xlsx");
        }
 
    }