excel = luacom.CreateObject("Excel.Application") excel.Visible = true excel.Workbooks:Add() -- Here we call the default method -- notice we DID NOT use the colon, as -- the object used is Sheets, not excel sheet = excel.Sheets(1) print(sheet.Name) -- Here we also call the default method -- We must supply the self parameter sheets = excel.Sheets sheet2 = sheets(2) print(sheet2.Name) -- Setting values excel.Sheets(1).Name = "MySheet1" excel:Quit()
This can be very useful when dealing with collections, as commonly they have a default Item property.
WARNING: one must be careful not to put the colon when using default methods of LuaCOM objects contained in table or in other LuaCOM objects (see the sample above).