Processing 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.