IntroBy using Excel's existing internal calculator, ExcelWriter allows you to make calculations in your report.
In order to calculate values in some cells of a report, simply format those cells in the template file to have the desired formula. Then, when the data is bound to the template and the report is open, the cells with formulas in them will be updated.
In this example we have a sample loan calculator. By simply binding the loan amount, annual interest rate, loan period and the start date of the loan, we can create a report with a plan for how to pay off the loan in the given loan period.
- Template: LoanCalculatorTemplate.xlsx
- Output: LoanCalculator_output.xlsx