excel.getCells
Get a range of cells to a 2D array.
bookID number
worksheetIndex number
startX number
startY number
countX number
countY number
cells 2D array (in format cells[yRow][xCol])
local xl = excel.load("c:\\test.xls")
if xl < 1 then
print("Error loading workbook")
else
local cells = data.createGrid()
local cells = getCells(0, 1, 1, 1, 10)
data.ui.showGridViewerDialog("Data", cells)
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)