excel.getCell
Description
Get a cell value.

Parameters
bookID number
worksheetIndex number
cellX number
cellY number

Return value
value string

Example
local xl = excel.load("c:\\test.xls")
if xl < 1 then
    print("Error loading workbook")
else
    -- print value in cell 1,1
    local value = data.getCell(xl, 0, 1, 1)
    print(value)

    -- close the workbook
    excel.close(xl)
end if

Comments
cellX and cellY cell coordinates are 1 based.

See also
setCell
getCells
setCells

Back
Generated on the 26 June 2024 at 22:01:28 (UK Time)