luacom and excel

[David Manura <dm.gmane@...>]

Does anyone know why the last line here fails?

  -- test.lua
  require('luacom')
  excel = luacom.CreateObject("Excel.Application")
  excel.Visible = true
  wb = excel.Workbooks:Add()
  ws = wb.Worksheets(1)
  ws.Cells(1,1).Value = "test"

  COM exception:(.\src\library\tLuaCOM.cpp,398):Type mismatch.
  stack traceback:
        [C]: ?
        stdin:1: in main chunk
        [C]: ?

It works fine in JavaScript (cscript.exe):

  // test.js
  excel = WScript.CreateObject("Excel.Application");
  excel.Visible = true;
  wb = excel.Workbooks.Add();
  ws = wb.Worksheets(1);
  ws.Cells(1,1).Value = "test";

I tried this with luacom 1.3 in Lua 5.0.2 since luacom is slightly broken in Lua
5.1 as noted here: http://lua-users.org/lists/lua-l/2006-02/msg00571.html 

--davidm