GNATCOM interface with MS Excel, Word

GNATCOM interface with MS Excel, Word

[Rebecca & Firinde]

Hi,

Can someone give a written and concrete example of using GNATCOM to access 
MS Word or Excel.

Thanks. 

Re: GNATCOM interface with MS Excel, Word

[Stephen Leake]

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

> Hi,
>
> Can someone give a written and concrete example of using GNATCOM to access 
> MS Word or Excel.

A better place to ask for this is on the GNAVI list
(http://sourceforge.net/projects/gnavi/) that is the mailing list for
GNATCOM.

-- 
-- Stephe

Re: GNATCOM interface with MS Excel, Word

[tmoran]

> > Can someone give a written and concrete example of using GNATCOM to access
> > MS Word or Excel.
> A better place to ask for this is on the GNAVI list
> (http://sourceforge.net/projects/gnavi/) that is the mailing list for
> GNATCOM.
   I downloaded gnatcom 1.4, installed it, and ran bindcom excel.exe
without success.

Re: GNATCOM interface with MS Excel, Word

[Jeff Creem]

tmoran@acm.org wrote:
>>>Can someone give a written and concrete example of using GNATCOM to access
>>>MS Word or Excel.
>>
>>A better place to ask for this is on the GNAVI list
>>(http://sourceforge.net/projects/gnavi/) that is the mailing list for
>>GNATCOM.
> 
>    I downloaded gnatcom 1.4, installed it, and ran bindcom excel.exe
> without success.

Hmm..

I did the same thing and it at least appears to have worked. I ended up
with about 600 packages that appear to be a complete binding to excel.

GNATCOM 1.4 (removed the -gnatg switch that prevents it from building 
with any modern GCC version)

Mingw 4.1 (includes a version based on gcc 3.4.2)

Using Microsoft Excel 2002 10.6501.6714 SP3


In what way did it fail for you?

Re: GNATCOM interface with MS Excel, Word

[tmoran]

> >    I downloaded gnatcom 1.4, installed it, and ran bindcom excel.exe
> > without success.

> I did the same thing and it at least appears to have worked. I ended up
> with about 600 packages that appear to be a complete binding to excel.

> Using Microsoft Excel 2002 10.6501.6714 SP3

> In what way did it fail for you?

GNATCOM.ERRORS.COM_ERROR
HRESULT (2147654730) : Error loading type library/DLL.

Excel About says Excel 2000 (9.0.4402 SR-1)
The excel.exe in question is 7,159,853 bytes dated 7/22/2001 22:44:10

Re: GNATCOM interface with MS Excel, Word

[Frank Piron]

Am Sun, 19 Jun 2005 10:01:38 +0200 schrieb Rebecca & Firinde 
<fteylouni@mydiax.ch>:

> Hi,
>
> Can someone give a written and concrete example of using GNATCOM to 
> access
> MS Word or Excel.

I wrote a small package for winword and a test client too. This is based 
on the packages which you get by running bindcom on MSWORD.olb.

Re: GNATCOM interface with MS Excel, Word

[bubble]

hi Rebecca:
this is sample code , I have test it in Offce 2003
I got only problem is the 3rd parameter in create method.
the default gnatcom for the 3rd is CLSCTX_ALL,
in most case,it work fine but in excel ,you must change 3rd parameter to 
CLSCTX_LOCAL_SERVER.
DO NOT USE GANTCOM 's DEFAULT VALUE





with Excel11.Workbooks_Interface;
with Excel11.uWorkbook_interface;
with Excel11.Application_Interface;
with Excel11.uApplication_Interface;
with Excel11.Sheets_Interface;



with Gnatcom.Initialize;
with Gnatcom.types;
with gnatcom.variant;

with gnatcom.dispinterface;

with Interfaces.C;
use Interfaces.C;

procedure TestExcel is

   app : Excel11.uApplication_Interface.uApplication_Type;
   wbs : Excel11.Workbooks_Interface.Workbooks_Type;
   wb :  Excel11.uWorkbook_interface.uWorkBook_type;
   sheets:Excel11.Sheets_Interface.Sheets_Type;
   sheet:gnatcom.dispinterface.dispinterface_type;
   cellRange:gnatcom.dispinterface.dispinterface_type;


   use Excel11;
   use gnatcom.types;
   use gnatcom;
begin
   Gnatcom.Initialize.Initialize_COM;

   uApplication_Interface.create(
               app,
               "Excel.Application",
               CLSCTX_LOCAL_SERVER);


   uApplication_Interface.Put_Visible(
                app,
                0,
                VARIANT_BOOL_TRUE);

   Workbooks_Interface.Attach(
               wbs,
               uApplication_Interface.Get_Workbooks(app)
               );

   uWorkbook_interface.Attach(wb,
                 Workbooks_Interface.Add(this=>wbs,
                             lcid=>0)
                );

   Sheets_Interface.Attach(sheets,
               uWorkbook_interface.Get_Worksheets(this=>wb)
               );

   dispinterface.Attach(
             sheet,
             Sheets_Interface.Add(this=>sheets,lcid=>0)
             );

  declare
   retValue:gnatcom.types.variant;
   a1:dispinterface.Parameter_Array:= (
                  1=> gnatcom.variant.To_Variant("A1")
                  );
  begin
   retValue :=dispinterface.Get(sheet,"Range",a1);
   dispinterface.attach(
             cellrange,
             gnatcom.variant.To_Pointer_To_IDispatch(retValue)
             );
  end;

  dispinterface.put(
           cellrange,
           "value",
           gnatcom.variant.To_VARIANT("ada call excel")
           );
 Gnatcom.Initialize.uninitialize_COM;

end testExcel;