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 SpreadsheetRefer to the following images for sample illustrations.
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.
Windows Forms use the class ExceRWCalcWorkbook to access a XLS file and calculate values using the file.