Page tree
Skip to end of metadata
Go to start of metadata

Intro

By 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. 

Requirements

This sample requires OfficeWriter Enterprise Edition to be installed because the OfficeWriter Grouping and Nesting is only available in the Enterprise Edition of the product.

 

Code

Downloads

  • No labels