luacom icon indicating copy to clipboard operation
luacom copied to clipboard

luacom for Excel.Application broken

Open xoner2 opened this issue 13 years ago • 1 comments

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 ()

xoner2 avatar Dec 04 '12 07:12 xoner2

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

wunoman avatar Feb 23 '24 08:02 wunoman