search

davidm / luacom

Microsoft Component Object Model (COM) binding for Lua
http://lua-users.org/wiki/LuaCom
Other
116 stars 51 forks source link

luacom for Excel.Application broken #7

Open xoner2 opened 11 years ago

xoner2 commented 11 years ago

Used to work on my Windows XP and Windows 7 PC's. Now crashes on both. I was using the luacom.dll that came with LuaForWindows.

I suspect a windows update might be causing the crash??

luacomE.ExportConstants works for a case like:

excel = luacom.CreateObject("Excel.Application") luacomE.ExportConstants (excel, excel)

but exporting to another table crashes:

excel = luacom.CreateObject("Excel.Application") xl = {} luacomE.ExportConstants (excel, xl)

this one also crashes at UsedRange:

local excel = luacom.CreateObject("Excel.Application") local book = excel.Workbooks:Open(...) local sheet = book.Worksheets(1) local input_values = sheet.UsedRange ()

wunoman commented 6 months ago

local input_values = sheet.UsedRange () used follow instead local input_values = sheet.UsedRange