Intro
Excerpt |
---|
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.
...
Note | ||||
---|---|---|---|---|
| ||||
|
\
Code
...
Code Block |
---|
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"); } } |
Downloads
- Template: LoanCalculatorTemplate.xlsx
- Output: LoanCalculator_output.xlsx