ASP.NET Samples

Amortization Calculator

This sample extends the Simple Loan Calculator with an amortization table which is displayed in an ASP.NET DataGrid control. Of particular interest is the use of the defined name, AmortizationTableForNPer, which uses the OFFSET() worksheet function to return a dynamically sized range.
[Run Sample]  | [View XLS]
Download SpreadsheetGear