Autofit row height in XLS files from Node.js application

[acetonic]

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 ?

Edit: Changed subject, was Autofit row height  Make your post understandable by others  -- MrProgrammer, forum moderator

[Zizi64]

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

[acetonic]

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.

[Zizi64]

https://www.openoffice.org/framework/sc ... guide.html
https://wiki.openoffice.org/wiki/Docume ... ipt_Editor

I never used JS for controlling the AOO/LO

[UnklDonald418]

When using the LO/OO API with JAVA see
http://fivedots.coe.psu.ac.th/~ad/jlop/

Edit: 2023-12-24: Broken link -- MrProgrammer, forum moderator