LuaCOMの例

Lua

Excelのセルに値を書き込んで、読みだす例。

require 'luacom'

excel = luacom.CreateObject('Excel.Application')
excel.Visible = true
local book  = excel.Workbooks:Add()
local sheet = book.Worksheets(1)

sheet.Cells(1, 1).Value2 = 99
local val = sheet:Range('A1'):Value()
print(val)

excel.DisplayAlerts = false
excel:Quit()
excel = nil

参考