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!sn-xit-04!sn-xit-08!sn-post-01!supernews.com!news.supernews.com!not-for-mail From: Chris Humphries Newsgroups: comp.lang.ada Subject: Re: excel files Date: Wed, 06 Oct 2004 07:58:10 -0400 Organization: Posted via Supernews, http://www.supernews.com Message-ID: <4163DDD2.6030706@unixfu.net> User-Agent: Mozilla Thunderbird 0.8 (X11/20040926) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <20041005193515.6C38A4C409F@lovelace.ada-france.org> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Xref: g2news1.google.com comp.lang.ada:4797 Date: 2004-10-06T07:58:10-04:00 List-Id: stephane richard wrote: > "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. > > Does anyone have any portable Ada code to offer for parsing excel files? I am a newbie to COM and MFC (well knew it about 6 years ago), and do not understand how to go about using ODBC or GNATCOM to do the suggested solutions to this problem. Can someone post some code showing how to do this, please :) > > > >>Andrew Carroll >>Carroll-Tech >>720-273-6814 >>andrew@carroll-tech.net >> >> > > >