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

3

Hello,

It’s difficult to pinpoint the exact reason why you’re not getting the value correctly without more context about the specific environment and libraries you’re using. However, based on the syntax you’ve provided, it looks like you might be using a scripting environment or a specific library that has a custom syntax for interacting with Excel files.

Here’s a breakdown of potential issues and things to check, along with some general guidance:

Potential Issues and Things to Check:

Case Sensitivity: Ensure that excelName and sheetName variables have the exact correct capitalization as they appear in your file system and within the Excel file.

File Path: Verify that ResourcePath(excelName&“.xlsx”) correctly resolves to the absolute or relative path of your Excel file. If the file is not in the expected location, the Workbook() function might fail or open a different file.

Best Regards
Vanila164