ADA Excel API

ADA Excel API

[Rebecca & Firinde]

Hi,

I am looking for an Ada API to access Microsoft Spreadsheets, on Windows. 
Needed operations are simple like open, close a workbook, open a sheet and 
access a cell /read & write).

Thanks. 

Re: ADA Excel API

[Stephen Leake]

"Rebecca & Firinde" <fteylouni@mydiax.ch> writes:

> I am looking for an Ada API to access Microsoft Spreadsheets, on Windows. 
> Needed operations are simple like open, close a workbook, open a sheet and 
> access a cell /read & write).

I have not done it, but GNATCOM can generate an Ada binding to the COM
interface to Excel.

See http://sourceforge.net/projects/gnavi/ for GNATCOM.

-- 
-- Stephe

Re: ADA Excel API

[Marius Amado Alves]

> I am looking for an Ada API to access Microsoft Spreadsheets, on 
> Windows.

Sometime ago I looked for this and didn't find it. My solution was 
generating a file format that Excel could import (I thing it was 
';'-delimited). Of course if you need live, direct interaction with 
Excel this won't do.

Re: ADA Excel API

[tmoran]

>I have not done it, but GNATCOM can generate an Ada binding to the COM
>interface to Excel.
   Where might one find a .tlb file and an API description for the COM
interface to Excel?

Re: ADA Excel API

[John B. Matthews]

In article <TuGse.1682$hV3.658@nntpserver.swip.net>,
 "Rebecca & Firinde" <fteylouni@mydiax.ch> wrote:

> Hi,
> 
> I am looking for an Ada API to access Microsoft Spreadsheets, on Windows. 
> Needed operations are simple like open, close a workbook, open a sheet and 
> access a cell /read & write).
> 
> Thanks. 

If you can write a servlet or cgi program in Ada, you can set the 
content type to "application/vnd.ms-excel" and output tab delimited 
text. When you fetch the corresponding page, many browsers will save it 
as an Excel file.

-- 
John
jmatthews at wright dot edu
www dot wright dot edu/~john.matthews/

Re: ADA Excel API

[Pascal Obry]

"Rebecca & Firinde" <fteylouni@mydiax.ch> writes:

> I am looking for an Ada API to access Microsoft Spreadsheets, on Windows. 
> Needed operations are simple like open, close a workbook, open a sheet and 
> access a cell /read & write).

Does Excel support SOAP Web Services? If so you could use AWS.

Another option, as others have pointed to you and as I pointed to you in
fr.comp.lang.ada, is to use GNATCOM.

Pascal.

-- 

--|------------------------------------------------------
--| Pascal Obry                           Team-Ada Member
--| 45, rue Gabriel Peri - 78114 Magny Les Hameaux FRANCE
--|------------------------------------------------------
--|              http://www.obry.net
--| "The best way to travel is by means of imagination"
--|
--| gpg --keyserver wwwkeys.pgp.net --recv-key C1082595

Re: ADA Excel API

[Stephen Leake]

tmoran@acm.org writes:

>>I have not done it, but GNATCOM can generate an Ada binding to the COM
>>interface to Excel.
>    Where might one find a .tlb file and an API description for the COM
> interface to Excel?

That I don't know. Try asking on the gnavi list; a while ago, someone
there reported interfacing to Microsoft Word via GNATCOM.

See http://sourceforge.net/projects/gnavi/ for the gnavi list.

Here's the specific link to that report:
http://sourceforge.net/mailarchive/message.php?msg_id=11390072

On the other hand, typing "word type library" into the search box at
www.microsoft.com leads to this page:

http://support.microsoft.com/default.aspx?scid=kb;en-us;143434

That says the type library was provided with Word 97. I have Word
2002; Msword*.olb is not on my disk. Searching for *.tlb and *.olb
turned up quite a bit of stuff, but nothing that looks like Word.

There is also lots of other information in the Microsoft search
results, but nothing that jumps up and says "here's the Word API".

This link looks like a good starting point:
 
http://support.microsoft.com/kb/152023/EN-US/

It may be that you have to buy an MS developer's license. 

Good luck!

-- 
-- Stephe

Re: ADA Excel API

[Jeff Creem]

Stephen Leake wrote:
> tmoran@acm.org writes:
> 
> 
>>>I have not done it, but GNATCOM can generate an Ada binding to the COM
>>>interface to Excel.
>>
>>   Where might one find a .tlb file and an API description for the COM
>>interface to Excel?
> 
> 
> That I don't know. Try asking on the gnavi list; a while ago, someone
> there reported interfacing to Microsoft Word via GNATCOM.
> 
> See http://sourceforge.net/projects/gnavi/ for the gnavi list.
> 
> Here's the specific link to that report:
> http://sourceforge.net/mailarchive/message.php?msg_id=11390072
> 
> On the other hand, typing "word type library" into the search box at
> www.microsoft.com leads to this page:
> 
> http://support.microsoft.com/default.aspx?scid=kb;en-us;143434
> 
> That says the type library was provided with Word 97. I have Word
> 2002; Msword*.olb is not on my disk. Searching for *.tlb and *.olb
> turned up quite a bit of stuff, but nothing that looks like Word.
> 
> There is also lots of other information in the Microsoft search
> results, but nothing that jumps up and says "here's the Word API".
> 
> This link looks like a good starting point:
>  
> http://support.microsoft.com/kb/152023/EN-US/
> 
> It may be that you have to buy an MS developer's license. 
> 
> Good luck!
> 

Bindcom works on more than just type libraries. It will run on .dlls and 
.exes that have the appropriate information in them.

There used to be (perhaps still is) a tool called gbmanager that David 
distributed as a separate download with GNATCOM .

It showed you everything that was installed (registered) on your system 
that you could use to create COM bndings.

Running it now it looks like with office XP that you can run using 
excel.exe and get a hundred or so Ada binding files for excel.

Re: ADA Excel API

[Dmitry A. Kazakov]

On Fri, 17 Jun 2005 22:37:34 +0200, Rebecca & Firinde wrote:

> I am looking for an Ada API to access Microsoft Spreadsheets, on Windows. 
> Needed operations are simple like open, close a workbook, open a sheet and 
> access a cell /read & write).

If you are familiar with SQL, you can use GNADE ODBC bindings (Exell tables
are accessible through ODBC.)

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de

Re: ADA Excel API

[Gautier Write-only]

Rebecca & Firinde:

> Hi,
> 
> I am looking for an Ada API to access Microsoft Spreadsheets, on Windows.
> Needed operations are simple like open, close a workbook, open a sheet and
> access a cell /read & write).

A weak but easy solution is to use DDE (an old MS technology).
You can do all you describe with it.
Look at win_paqs.zip, dde_test.adb, part about Excel.

HTH
______________________________________________________________
Gautier     --     http://www.mysunrise.ch/users/gdm/index.htm
Ada programming -- http://www.mysunrise.ch/users/gdm/gsoft.htm

NB: For a direct answer, e-mail address on the Web site!

Re: ADA Excel API

[Frank Piron]

Am Fri, 17 Jun 2005 18:06:51 -0500 schrieb <tmoran@acm.org>:

>> I have not done it, but GNATCOM can generate an Ada binding to the COM
>> interface to Excel.
>    Where might one find a .tlb file and an API description for the COM
> interface to Excel?

Run bindcom e.g. on XL5EN32.olb

Re: ADA Excel API

[tmoran]

> Run bindcom e.g. on XL5EN32.olb
results in:
GNATCOM.ERRORS.COM_ERROR
HRESULT (2147654730) : Error loading type library/DLL.

I ran a different Ada binding generator on XL5EN32.OLB and it ran to
completion.  I also ran both on EXCEL9.OLB, where both generated
partial results before complaining and quiting.

Is there a naming convention or something or how should a person
learn that excel's tlb is named XL5EN32.OLB?  That's not very obvious.

The two files were:
EXCEL9  .OLB  638976 03/19/99 13:00:32
XL5EN32 .OLB  228864 01/06/99 16:50:18

Re: ADA Excel API

[Frank Piron]

Am Wed, 22 Jun 2005 03:29:18 -0500 schrieb <tmoran@acm.org>:

>> Run bindcom e.g. on XL5EN32.olb
> results in:
> GNATCOM.ERRORS.COM_ERROR
> HRESULT (2147654730) : Error loading type library/DLL.

If i remember right, i got this error too in one of my attempts. But after 
rebuilding GNATCOM all worked fine.

> I ran a different Ada binding generator on XL5EN32.OLB and it ran to
> completion.  I also ran both on EXCEL9.OLB, where both generated
> partial results before complaining and quiting.
>
> Is there a naming convention or something or how should a person
> learn that excel's tlb is named XL5EN32.OLB?  That's not very obvious.

Agreed. I scanned the office directory for all kinds of type libraries and 
found it. The MS-Poets excel themselves in creativity.
BTW: Does anybody know what the EXCEL acronym means?

Frank piron

Re: ADA Excel API

[Frank J. Lhota]

Frank Piron wrote:
> ...
> BTW: Does anybody know what the EXCEL acronym means?

I think the name EXCEL refers to the fact that a spreadsheet is made up 
of cells. In other words, EXCEL is a pun, not a acronym.

> Frank piron

Re: ADA Excel API

[Frank J. Lhota]

Frank Piron wrote:
> ...
> BTW: Does anybody know what the EXCEL acronym means?

I think the name EXCEL refers to the fact that a spreadsheet is made up 
of cells. In other words, EXCEL is a pun, not a acronym.

> Frank piron

Re: ADA Excel API

[Frank J. Lhota]

Frank Piron wrote:
> ...
> BTW: Does anybody know what the EXCEL acronym means?

I think the name EXCEL refers to the fact that a spreadsheet is made up
of cells. In other words, EXCEL is a pun, not a acronym.

> Frank piron

Re: ADA Excel API

[Frank J. Lhota]

Frank Piron wrote:
> ...
> BTW: Does anybody know what the EXCEL acronym means?

I think the name EXCEL refers to the fact that a spreadsheet is made up
of cells. In other words, EXCEL is a pun, not a acronym.

> Frank piron

Re: ADA Excel API

[Frank J. Lhota]

Frank Piron wrote:
> ...
> BTW: Does anybody know what the EXCEL acronym means?

I think the name EXCEL refers to the fact that a spreadsheet is made up
of cells. In other words, EXCEL is a pun, not a acronym.

> Frank piron

Re: ADA Excel API

[Frank J. Lhota]

Frank Piron wrote:
> ...
> BTW: Does anybody know what the EXCEL acronym means?

I think the name EXCEL refers to the fact that a spreadsheet is made up
of cells. In other words, EXCEL is a pun, not a acronym.

> Frank piron

Re: ADA Excel API

[Frank J. Lhota]

Frank Piron wrote:
> ...
> BTW: Does anybody know what the EXCEL acronym means?

I think the name EXCEL refers to the fact that a spreadsheet is made up
of cells. In other words, EXCEL is a pun, not a acronym.

> Frank piron

Re: ADA Excel API

[Frank J. Lhota]

Frank Piron wrote:
> ...
> BTW: Does anybody know what the EXCEL acronym means?

I think the name EXCEL refers to the fact that a spreadsheet is made up
of cells. In other words, EXCEL is a pun, not a acronym.

> Frank piron

Re: ADA Excel API

[Frank J. Lhota]

Frank Piron wrote:
> ...
> BTW: Does anybody know what the EXCEL acronym means?

I think the name EXCEL refers to the fact that a spreadsheet is made up
of cells. In other words, EXCEL is a pun, not a acronym.

> Frank piron

Re: ADA Excel API

[Frank J. Lhota]

Frank Piron wrote:
> ...
> BTW: Does anybody know what the EXCEL acronym means?

I think the name EXCEL refers to the fact that a spreadsheet is made up
of cells. In other words, EXCEL is a pun, not a acronym.

> Frank piron

Re: ADA Excel API

[Frank J. Lhota]

Sorry, I only meant to send this once. I'm having problems with my 
newsgroup account. :(

Re: ADA Excel API

[bubble]

another way.

Excel 97 SDK provide a C API to call excel.
you can search "Xloper" and "Excel 97 SDK" in google