Example of Compute All Formulas in ASP.NET MVC Excel (XlsIO) Library
This sample demonstrates how to use formulas in spreadsheets using Excel (XlsIO) Library.
DEMO
SOURCE
Essential XlsIO can compute the values of a formula entered during run time using the calculate engine that is integrated in XlsIO. This makes it possible to retrieve the values of formulas that were entered using Excel (XlsIO) Library during run time. Currently, over 400 functions are supported, which covers all common usage scenarios.
Features:
- Writing formulas using Excel (XlsIO) Library
- Formula calculation using the integrated calculate engine