Access OpenOffice spreadsheet

The Application Programming Interface and the OASIS Open Document Format

Access OpenOffice spreadsheet

Postby Haripriya » Wed Oct 16, 2019 1:55 pm

Hi Folks,
Can u pls let me know whether we can programmatically access open office spreadsheet..
i am trying to use open office excel as an alternative for microsoft excel

i used to read excel, copy, paste, merge cells, processing macros all these functions i have programmatically using c# in microsoft office using libraries like interop excel and epplus

Can all these activities be done in open office spreadsheet programmatically in c# using compatible libraries for open office

Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply (Hagar, Moderator).
OpenOffice 4.1.7 on Windows 10
Haripriya
 
Posts: 1
Joined: Wed Oct 16, 2019 1:09 pm

Re: Open office

Postby RoryOF » Wed Oct 16, 2019 2:04 pm

Yes, all this can be done in OpenOffice, but you will need (read: MUST) rewrite all your macros. Better to stick with Excel if that is working for you - the cost of Excel will be less than the true cost in time and effort of migrating to OpenOffice.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29778
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Open office

Postby Zizi64 » Wed Oct 16, 2019 4:16 pm

Try the LibreOffice. It has a littlebit higher compatibility level with the VBA macros, but it is better to rewrite all your Excel macros based on the AOO/LO API. API : Application Programming Interface.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.3.3; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8486
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Access OpenOffice spreadsheet

Postby JeJe » Wed Oct 16, 2019 9:37 pm

OpenOffice macros can be written in OpenOffice Basic, Python, Beanshell, and Javascript but not c#.

On Windows you can use automation to control OpenOffice though and use different languages.

https://www.openoffice.org/udk/common/m ... ation.html

Your examples are very simple - copy, paste, merge cells - you could probably easily generate some (Basic) code to do these using the macro recorder.

Edit: oops corrected slip up - OpenOffice Basic.
Last edited by JeJe on Thu Oct 17, 2019 11:11 am, edited 1 time in total.
Openoffice 4.1.2
Windows 8
JeJe
Volunteer
 
Posts: 613
Joined: Wed Mar 09, 2016 2:40 pm

Re: Access OpenOffice spreadsheet

Postby Zizi64 » Thu Oct 17, 2019 6:48 am

OpenOffice macros can be written in Visual Basic, Python, ...

The Basic language and IDE of the Apache OpenOffice/LibreOffice is not same as the Visual Basic of the Microsoft.
It is the StarBasic (this name inherited from the ancestor: named StarOffice) and you can/must use together with the unique Application Programming Inteface functions and procedures of the AOO/LO.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.3.3; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8486
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to UNO API and ODF

Who is online

Users browsing this forum: No registered users and 2 guests