How to export data from Visual Basic to "OpenOffice.org Calc" spreadsheet?

Good Days,
I have a problems exporting data from VB to "OpenOffice.org calc" spreadsheet? It is totally different from Microsoft Excel..
Hope to get u all assistances..

thank u very much

 

What is the exact problem you are facing??

 

the most problem i am facing is i dont know how to code it. It's unlike Microsoft Excel..

dim oExcel as Excel.Application
dim oWs as Excel.Worksheet
dim 0Wb as Excel.workbook
.
.
.
.
.

but for OpenOffice.org calc, i dont know how to export data from VB to this kind of spreadsheet.

 

Create a normal Excel file, OpenOffice supports MS Excel format!

 

In my company, all the pc are using free software, "OpenOffice.org". Now i was assigned to create programs to generate reports. If they use Microsoft Products, i can still manage to do it. Now it's different....