Programming with Openoffice.org Calc in VB.Net

[kishu]

Hi All,

Can anyone help me to programme with "OpenOffice.org calc" in vb.net.
Actually i have a vb.net application which deals with MS Excel to read and write data, now i want to support same for "OpenOffice.org calc" also.

I have already installed "OpenOffice.org calc" in my machine (windows xp), Can anybody suggest which DLL's needs to add as references to vb.net IDE.
It helps me a lot if you have provided some sample code.

Thanks in advance,
Kishore.

[B Marcelly]

Can anyone help me to programme with "OpenOffice.org calc" in vb.net.

I have already installed "OpenOffice.org calc" in my machine (windows xp), Can anybody suggest which DLL's needs to add as references to vb.net IDE.

Hi,
Programming questions should be posted in section Macros and Uno API. The sub-section External Programs could be used for such a question.

There is no specific DLL to add. OpenOffice is all you need. Note that OpenOffice.org does not provide a « type library » for COM. Consequently you can only use IDispatch interface and « late binding ».

Programming OpenOffice.org through VB.NET can be very similar to code from OOo Basic macros.
In the VBx OOo tools you will find explanations, many helper routines, and examples to handle easily OpenOffice.org through VB.NET.

To learn how to use the OpenOffice.org API you should search the internet for OOoBasic tips and documentation, or read a book on OOo Basic programming.

[Hagar Delest]

Programming questions should be posted in section Macros and Uno API. The sub-section External Programs could be used for such a question.

Thread moved.