Click here to Skip to main content
15,898,134 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello,

I have a vb.net application which takes data and writes it to a MS Excel spreadsheet. Am using MS Excel dll "Interop.Excel" or this.

Now i want to support same functionality for "OpenOffice calc" also.
My sample code looks like,

Imports Microsoft.Office.Interop

Dim xlApp As Excel.Application
Dim xlBooks As Excel.Workbooks
Dim xlBook As Excel.Workbook

Try
   xlApp = New Excel.Application
   xlBooks = xlApp.Workbooks
   xlBook = xlBooks.Open(FileName)
   bExcelOpen = True
Catch ex As Exception
   bExcelOpen = False
Finally etc....


I have searched on Google regarding this, but am not able to get relevant information.

Can please anyone suggest me the approach like, OpenOffice Calc DLL's info and equivalent class for 'Excel.Application' with some sample code.

Thanks in advance,
Posted
Updated 17-Sep-12 3:45am
v2
Comments
ZurdoDev 17-Sep-12 8:13am    
I would start with their developers' site, http://incubator.apache.org/openofficeorg/get-involved.html

1 solution

There is an SDK for OpenOffice: http://www.openoffice.org/download/sdk/[^]
But beware: it works totally different from what you are used to with Excel!
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900