Spreadsheet Document API - How to Create a Loan Amortization Schedule within a .NET 6 Blazor Server App

This example demonstrates how to create a Blazor Server application that targets .NET 6 and leverages the capabilities of the DevExpress Spreadsheet Document API to build a loan amortization schedule.

The application allows users to enter loan information (loan amount, repayment period in years, annual interest rate, and start date). Once data is entered, the Spreadsheet immediately recalculates loan payments and updates data on the application page. Users can export the result to XLSX or PDF as needed.

To run this application, you need to install or restore the following NuGet packages:

• DevExpress.Document.Processor - Contains the DevExpress Office File API libraries.

• DevExpress.Blazor - Contains all DevExpress Blazor UI components.

Documentation

Refer to this help topic for implementation details: Use the Spreadsheet Document API to Create a Loan Amortization Schedule within a Blazor Server App.

Files to Look At

• DocumentGenerator.cs

• DocumentService.cs

• ExportController.cs

• Index.razor

More Examples

• Word Processing Document API – How to Generate and Send Business Letters within a Blazor Server App
• How to Dockerize an Office File API Application