1. RE: Interface with Microsoft Excel
> -----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.
You have a couple of options. First, you could use ODBC to read/write the
Excel file (there's an ODBC lib in the archives). Alternatively, you could
connect to Excel through OLE/COM. This would probably be a bit more work,
at least initially, because no one's wrapped any Excel interfaces yet
(although you could use EuCOM--I've got most of the bugs out of it).
Matt Lewis
2. RE: Interface with Microsoft Excel
> -----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.
