Skip to main content
Version: v6.5.0

Read cells

Command Description

Read the value of a specified cell in the data table

Command Prototype

objRet = Datatable.ReadCell(dtTable, cell)

Command parameter

parametermandatorytypedefault valueInstructions
dtTableTrueexpressionobjDatatableThe read data table object, usually the return value of the "Build Data Table" command or the "Build Data Table from Excel Table" command
cellTrueexpression[1, 1]Specify the cells of the data table in a row column array format ([row number, column number]), such as [2,3], which represents the cell position at the intersection of the second row and the third column

Return result

ObjRet, Assign the result of running the command to this variable.

Run instance

/*********************************Read Cell***************************************
Command Prototype:
objRet = Datatable.ReadCell(dtTable, cell)
Input Parameters:
dtTable -- Data table object. Note: The data table object to be read, typically the return value of the "Build Data Table" command or the "Build Data Table from Excel" command.
cell -- Cell. Note: Specifies the cell in the data table, in row-column array format ([row number, column number]). For example, [2,3] represents the cell at the intersection of the 2nd row and 3rd column.
Output Parameter:
objRet -- The variable where the output of the function call will be saved.
Notes:
None
********************************************************************************/
Dim objRet = ""
objRet = Datatable.ReadCell(objDatatable, [1, 1])
TracePrint(objRet)