How do I read the value of an Excel cell that is computed by an Excel formula in real-time?

Eggplant Functional
1

I am trying to read a value from an Excel cell which is computed by an Excel formula. The related cell’s value in the formula is read as text from the SUT.
image

my code like this:
set MyExcelFile to Workbook(ResourcePath(excelName&“.xlsx”))
set MyExcelSheet to MyExcelFile.Worksheet(sheetName)
…
put the result into Cell(MyExcelSheet, [index,resultNum])
…
set paramName to MyExcelSheet.Cell(index2,index3)

But it seems I can’t get the value correctly. I would appreciate any help.

2

Good day!

Is there a reason that you want to read the value from Excel using the SUT window? Perhaps sharing more of your code would give us a better understanding of what you want to do and would allow us to test your code and see whether we are experiencing the same issue.

Thanks,
Dave

8

Since the SenseTalk Excel library doesn’t calculate formulas automatically, save and close the file after writing, or access the cell’s calculated value property directly using MyExcelSheet.Cell(index2, index3).value after recalculating.