excel.setCell
Description
Set a cell value.

Parameters
bookID number
worksheetIndex number
cellX number
cellY number
value string

Return value
success boolean

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

    -- save the workbook
    excel.save(xl)

    -- 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)