Version

Formula Values from an Excel File

The Infragistics Excel Engine™ now has the ability to retrieve the actual calculated values from Formulas that exist on an Excel® Worksheet. Previously, when attempting to programmatically access a Cell value of an Excel Cell that is composed of an Excel Formula, you would get the actual literal string that represents the Excel Formula. With this new feature, whether you are accessing Formulas created by the Excel Library’s object model or existing Formulas that were created through Microsoft® Excel, you now get the actual evaluated value of the formula.