Re: excel files

["stephane richard" <stephane.richard@verizon.net>]

"Andrew" <andrew@carroll-tech.net> 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 <adevaure@free.fr>
>> 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
>
>