Calculations

Essential XlsIO has advanced support for working with Formulas in cells.

Essential XlsIO has support for reading and writing formulas from and to cells in a worksheet. You can write any valid Excel formula into the cells.

It also supports the usage of Array formulas.

Essential XlsIO cannot only read the formulas in a cell, but can also compute their values using Essential Calculate. Our utility libraries automatically retrieve the values of related cells using XlsIO and compute the value of a formula using Essential Calculate, dynamically. It can also deal with nested formulas.

Currently there are over 150+ functions that can be computed by Essential Calculate which covers all common Excel functions.