From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00 autolearn=ham autolearn_force=no version=3.4.4 X-Google-Thread: 103376,b424ec4b490c1d84 X-Google-Attributes: gid103376,public X-Google-Language: ENGLISH,ASCII-7-bit Path: g2news1.google.com!news1.google.com!news.glorb.com!cyclone1.gnilink.net!spamkiller2.gnilink.net!gnilink.net!trndny05.POSTED!da342007!not-for-mail From: "stephane richard" Newsgroups: comp.lang.ada References: <20041005193515.6C38A4C409F@lovelace.ada-france.org> Subject: Re: excel files X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original Message-ID: Date: Wed, 06 Oct 2004 10:24:12 GMT NNTP-Posting-Host: 129.44.81.19 X-Complaints-To: abuse@verizon.net X-Trace: trndny05 1097058252 129.44.81.19 (Wed, 06 Oct 2004 06:24:12 EDT) NNTP-Posting-Date: Wed, 06 Oct 2004 06:24:12 EDT Xref: g2news1.google.com comp.lang.ada:4789 Date: 2004-10-06T10:24:12+00:00 List-Id: "Andrew" wrote in message news:mailman.208.1097055129.390.comp.lang.ada@ada-france.org... >> ------------------------------ >> Message: 6 >> Date: Tue, 05 Oct 2004 21:00:28 +0200 >> From: Alexandre Devaure >> Subject: Re: excel files >> tmoran@acm.org wrote: >> >>Depending on what you have in your Excel file, but you can use it as > a DB and >> >>use ODBC to access data. >> > >> > Can you access formulas and formatting via ODBC, or just values in > cells? >> >> What I want is just to read values in cells. >> ------------------------------ > I wonder if there is a way to create a binding to the libraries in > Visual Basic. In Visual Basic, and please excuse my "vocabulary" here, > you specify which libraries are associated with the project. There is a > list and you put little check marks next to the ones you want. Then you > can use the object browser to view what features that library adds. > Ahhhh, I can't remember all the menu's and menu labels and stuff, darn > it. I think I have early onset "old timers" disease. > > Anyway... > Those libraries are dll files (correct me if I am wrong). Isn't there a > way to import those into an Ada specification? If you could do that > then you could use the object browser in VB as your guide and write in > Ada! This way, you could "import" the Excel libraries and use them with > the same "robustness" as VB does instead of ODBC. > Well the real question is how robust is VB ? ;-). But seriously, most are ActiveX DLL's however VB's Excel library won't work unless you have Office Installed (with the option of installing the Development part of OFfice, hence VBA as well. The best way to describe these Office Objects is wrappers around an instance of the application. I'd rather work with something that doesn't need Excel at all but can still read the contents. But I don't matter in this thread since I'm not the original poster of the topic ;-). If you don't mind need excel installed, then you could use GWindows (from the adapower website) and probably importing the Excel classes. > Andrew Carroll > Carroll-Tech > 720-273-6814 > andrew@carroll-tech.net > >