OpenOffice Integration Sample

[SurenBehari]

 Posted by:  Suren Behari 

Hi,

There have been many requests for a sample to demonstrate the integration of OpenOffice with SQLWindows.

Please find attached a simple sample that demonstrates exporting Table Window data to an OpenOffice spreadsheet.
It invokes sCalc as an out-of-process application and populates an embedded ActiveX control.

I will provide detailed information and a wrapper class for all exposed APIs in my upcoming book - stay tuned.

Hope this helps.

Thanks,
Suren

[as]

 Posted by:  as 


I try to use it but get error on "oSheets.Invoke( 'getByName', INVOKE_FUNCTION )"

What´s wrong?

I'm using openOffice 2.0

[SurenBehari]

 Posted by:  Suren Behari 

Hi,

I use OpenOffice v2.2. I don't know what the default worksheet name was in 2.0, but another way to get the sheet is by index:
Replace

Code: Select all

Set bOk = oSheets.PushString( "Sheet1" )
Set bOk = oSheets.Invoke( 'getByName', INVOKE_FUNCTION )

with

Code: Select all

Set bOk = oSheets.PushNumber( 0, VT_I4 )
Set bOk = oSheets.Invoke( 'getByIndex', INVOKE_FUNCTION )

Thanks,
Suren

[Didier Tourneur]

 Posted by:  Didier Tourneur 

Yes but how display, the calc inside the form like a true ActiveX without use a container .
It's easier

Didier

[as]

 Posted by:  as 


Great, now it work

[Ingo Pohl]

 Posted by:  Ingo Pohl 

Could it be possible to have the app in text format so i could change the outlineversion to open it with my TD3.1

[as]

 Posted by:  as 

I export number using 'setValue' ( oCell.Invoke( 'setValue', INVOKE_FUNCTION ) )

How can I export date value?

[giacomo berzacola]

 Posted by:  Giacomo Berzacola 

Can I have the code in TXT format, I have version 2.1
Tanks Giacomo