public class LoanCalculator
    {
        //Variables needed for calculations:
        private double principal = 1000.00d;
        private double apr = 2.99d;
        private int numyears = 5;
        private DateTime date = DateTime.Now;

        /// <summary>
        /// Build the report with ExcelTemplate
        /// </summary>
        public void GenerateReport()
        {

            //* Create an instance of ExcelTemplate */
            ExcelTemplate xlt = new ExcelTemplate();

            //* Open the template workbook */
            string templatePath = @"..\..\templatesExcelTemplateFiles\LoanCalculatorTemplate.xlsx";
            xlt.Open(templatePath);

            //* Pass the data to the BindCellData method
            //* and specify the data source name
            */
            DataBindingProperties bindingProperties = xlt.CreateDataBindingProperties();
            xlt.BindCellData(principal, "Principal", bindingProperties);
            xlt.BindCellData(apr / 100, "APR", bindingProperties);
            xlt.BindCellData(numyears, "N", bindingProperties);
            xlt.BindCellData(date, "Date", bindingProperties);

            //* Call the Process() method to populate the template with the data source values */
            xlt.Process();

            // Save the report
            xlt.Save(@"..\..\OutputExcelOutputFiles\LoanCalculator_output.xlsx");
        }
    }