This sample demonstrates how to use formulas in spreadsheets using XlsIO.
DEMO
SOURCE
Formulas are entries in Excel that have an equation that calculates the value to be displayed. A typical formula might contain cells, constants, and even functions. Essential XlsIO has support for reading and writing formulas.