OpenEuphoria

RE: Interface with Microsoft Excel

• Posted by Matthew Lewis <matthewwalkerlewis at YAHOO.COM> May 24, 2001
• 477 views

> -----Original Message-----
> From: msuclay at hotmail.com [mailto:msuclay at hotmail.com]

> Can someone tell me if there is a way to read an excel file 
> with Euphoria 
> and based upon data do some calculations and then output the 
> data back to an 
> excel file.  Any information or examples would be greatly appreciated.

I've been working on EuCOM, and am able to connect to Excel (I have 97).
However, I've been very unsuccessful in getting Automation to work.  I keep
getting error #80028018 (Old format or invalid type library).  I can't
figure out why this happens (it's only with certain objects/members).  I've
been able to do things with Access without problem.  I noticed that there is
a typelib for Excel 95 on my computer, but I'm not sure I want to remove it
(and I'm not sure that it's the problem).

Matt Lewis

PS I've just about got a program to automatically wrap COM objects
(including ActiveX) done.