excel.setCells
Set a range of cells from a 2D array.
bookID number
worksheetIndex number
startX number
startY number
cells 2D array (in format cells[yRow][xCol])
success boolean
local xl = excel.load("c:\\test.xls")
if xl < 1 then
print("Error loading workbook")
else
local cells = data.createGrid()
data.setCell(cells, 0, 0, "Hello")
data.setCell(cells, 1, 0, "World")
setCells(xl, 0, 1, 1, cells)
excel.save()
excel.close(xl)
end if
startX and startY cell coordinates are 1 based.
Generated on the 26 June 2024 at 22:01:28 (UK Time)