Skip to main content
Version: v6.7.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)