XLS File Using CalcEngine Demo

This sample has the class ExcelRWCalcWorkbook that facilitates the working of Essential Calculate with XLS files, using Essential XlsIO. To add such support to your projects, add this class to the project and include Syncfusion.Calculate.Base and Syncfusion.XlsIO.Base as references.

Features:

This sample simulates a calculation engine that is designed as an Excel spreadsheet. The spreadsheet consists of four pages, as listed below.

The values are entered in the input sheet and the results are displayed on the output sheet, using calculations performed on the calculation sheet that reference the parameters on the lookup sheet. This is a typical use-case.

Excel Spreadsheet

Refer to the following images for sample illustrations.

Excel Spreadsheet

Excel Spreadsheet

Excel Spreadsheet

Excel Spreadsheet


As a front end of this calculation engine, this sample has Windows Forms where input values can be entered. On pressing a button, the form will pass the entered values to the input sheet and then retrieve the computed results from the output sheet. This sample also illustrates the use of a batch mode.

An image illustrating this window is displayed below.

Sample Calculator
Sample Calculator


Windows Forms Data Entry Screen

Windows Forms use the class ExceRWCalcWorkbook to access a XLS file and calculate values using the file.