data.getCell - Stock Tracker 5 Scripting Reference

data.getCell

Get a cell string value within a 2D array (grid) returned from data.loadCsvFile or data.runSelectQuery etc.

grid 2D array (in format cells[yRow][xCol])
xCol integer (one-based X/column index)
yRow integer (one-based Y/row index)

cellValue string (returns empty string if cell is invalid or empty)

-- get location names from Stock Tracker database
local cells = data.runSelectQuery("SELECT [LocationName] from [ItemLocations]")

-- get the first location name
local locationName = data.getCell(cells, 0,0)

print(locationName)

data.setCell
data.printCell