Getting the Value of a Formula from an Excel File

In order to get the evaluated value of an Excel Cell that is represented by a Formula, you simply access the value property of the WorksheetCell.

The example code below shows you how to access a particular Excel Worksheet Cell that is populated by an Excel Formula.

In JavaScript:

var calculatedValue = theWorksheet.rows(1).cells(4).value();

Related Topics

• Read an Excel File into a Workbook
• List of Supported Built-in Functions