Page 1 of 1
Autofit row height in XLS files from Node.js application
Posted: Thu Oct 27, 2022 1:03 pm
by 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 ?
Re: Autofit row height in XLS files from Node.js application
Posted: Thu Nov 10, 2022 7:52 am
by 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
Re: Autofit row height in XLS files from Node.js application
Posted: Tue Nov 15, 2022 10:39 am
by acetonic
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.
Re: Autofit row height in XLS files from Node.js application
Posted: Tue Nov 15, 2022 8:26 pm
by Zizi64
Re: Autofit row height in XLS files from Node.js application
Posted: Wed Nov 16, 2022 4:54 am
by 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 |