ReportCell() Function tp Access Cells in Report Table

Version: 2021b

Type: Features

Category: Programming

Subcategory: Labtalk

Jira: ORG-23395

Function added under Lookup & Reference to access report table cell. Using this new function will be much easier to access result cell values in Set Column Values and Labtalk Script.


ReportCell(string sBook$, string sSheet$, string sTable$, string sRowRef$, string sColRef$)

  • Active book will be used if sBook$ not specified.


In report sheet, active Parameters table, select the Value cell of y0, then the status bar will show the link address like “cell://Parameters.y0.Value”. Now you can call the ReportCell function like following to access the cell.

ReportCell(, "FitNL1", "Parameters", "y0", "value")

Also, you can use it in Set Values formula.