excel.setCell
Set a cell value.
bookID number
worksheetIndex number
cellX number
cellY number
value string
success boolean
local xl = excel.load("c:\\test.xls")
if xl < 1 then
print("Error loading workbook")
else
data.setCell(xl, 0, 1, 1, "Test")
excel.save(xl)
excel.close(xl)
end if
cellX and cellY cell coordinates are 1 based.
Generated on the 26 June 2024 at 22:01:28 (UK Time)