Hello!
We have a Node.js application where need to handle many xls files and autofit it row height.Is it possible to run headless OpenOffice calc application and run this function for a file, or use some js SDK ? How to realize this ?
You can control all of the functions and features of the AOO/LO by some macros using the API functions of the AOO /LO. (or you can control at least MOST of them.)
But, the AOO/LO has not 100% compatibility with the foreign and obsolete file formats like the .xls. Use the ODF file formats if you want to work with the AOO/LO so efficiently. The API of the AOO/LO and the contolling/programming environment of the MS Office are strongly different.
AOO = Apache OpenOffice
LO = LibreOffice
API = Application Programming Interface
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
Zizi64 wrote: ↑Thu Nov 10, 2022 7:52 am
You can control all of the functions and features of the AOO/LO by some macros using the API functions of the AOO /LO. (or you can control at least MOST of them.)
But, the AOO/LO has not 100% compatibility with the foreign and obsolete file formats like the .xls. Use the ODF file formats if you want to work with the AOO/LO so efficiently. The API of the AOO/LO and the contolling/programming environment of the MS Office are strongly different.
AOO = Apache OpenOffice
LO = LibreOffice
API = Application Programming Interface
How can I call API functions of AOO from JS code? There is no SDK for it.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
Edit: 2023-12-24: Broken link -- MrProgrammer, forum moderator
Last edited by MrProgrammer on Sun Dec 24, 2023 5:40 pm, edited 1 time in total.
Reason:Report broken link
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11