excel.getWorksheetIndex - Stock Tracker 5 Scripting Reference

excel.getWorksheetIndex

Get an Excel worksheet index by title.

bookID number
sheetTitle string

index number

local xl = excel.load("c:\\test.xls")
if xl < 1 then
    print("Error loading workbook")
else
    -- print index
    local index = excel.getWorksheetIndex(xl, "Sheet1")
    print("Index: " .. index)

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

Result index is zero based.