Communicate with data in Excel, in Ada

Communicate with data in Excel, in Ada

[Gautier Write-only-address]

Hello!

Has anyone tried to make I/O with data of an open sheet
in Excel, this in Ada (e.g. with GNAT) ? I suppose it
should be done through OLE (no clue about how to program it).
Is there a resource available on the Web ?
________________________________________________________
Gautier  --  http://www.mysunrise.ch/users/gdm/gsoft.htm
NB: Do not answer to sender address, visit the Web site!

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Re: Communicate with data in Excel, in Ada

[Ted Dennison]

In article <mailman.1007128903.21794.comp.lang.ada@ada.eu.org>, Gautier
Write-only-address says...
>Has anyone tried to make I/O with data of an open sheet
>in Excel, this in Ada (e.g. with GNAT) ? I suppose it
>should be done through OLE (no clue about how to program it).
>Is there a resource available on the Web ?

Back in the NT 3.5 days I did it using DDE. It worked really well. You may want
to look into what DDE's current level of support is.

---
T.E.D.    homepage   - http://www.telepath.com/dennison/Ted/TED.html

No trees were killed in the sending of this message. 
However a large number of electrons were terribly inconvenienced.

Re: Communicate with data in Excel, in Ada

[Jeff Creem]

I have looked at this a little. The best approach appears to be to use
GNATCOM
(www.adapower.com/com)

To produce a COM binding to the features of Excel.

Then take a look at the Microsoft Knowledge base examples for how to do this
from
Visual Basic. (Article Q219151)

The same approach should work with the Ada COM binding.

I don't remember which dll,ocx,tlb or exe I used in the Excel area that I
found the
COM stuff in. If you can't figure it out I can poke around and see what I
can find.


"Gautier Write-only-address" <gautier_niouzes@hotmail.com> wrote in message
news:mailman.1007128903.21794.comp.lang.ada@ada.eu.org...
> Hello!
>
> Has anyone tried to make I/O with data of an open sheet
> in Excel, this in Ada (e.g. with GNAT) ? I suppose it
> should be done through OLE (no clue about how to program it).
> Is there a resource available on the Web ?
> ________________________________________________________
> Gautier  --  http://www.mysunrise.ch/users/gdm/gsoft.htm
> NB: Do not answer to sender address, visit the Web site!
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>