Skip to content

Latest commit

 

History

History
37 lines (26 loc) · 1.48 KB

excelengine-getting-the-value-of-a-formula-from-an-excel-file.adoc

File metadata and controls

37 lines (26 loc) · 1.48 KB

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 pick:[win-forms=" Value"]pick:[asp-net=" Value"] property of the pick:[win-forms=" WorksheetCell"]pick:[asp-net=" WorksheetCell"] .

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

In Visual Basic:

lblValue.Text = theWorksheet.Rows[1].Cells[4].Value;

In C#:

lblValue.Text = theWorksheet.Rows[1].Cells[4].Value;