Ask Your Question

python method in libreoffice calc

asked 2019-06-16 18:35:39 +0200

leesmithUCSB gravatar image

I have about a hundred sheets in libroffice calc.

I would like to create a Python script that would create in a blank sheet a list of all of sheet names in a single column. Eash of the rows should hyperlink to a sheet name.

I have never used Python and LO calc before.

I assume that the Python code is kept in a python script [with .py extension].

Thanks in advance.


BTW: If you could direct me to a site that explains more generally how to use Python and Calc together, I would appreciate that too.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-06-16 20:15:21 +0200

Ratslinger gravatar image


A quick search revealed that this was already done by @karolus and posted here -> Re: How to get list of sheet names into a sheet. Quick test worked.

As for getting started with LO & Python that is going to take some work on your part. There is no one place. See my answer here -> Getting started writing Python macros and UDFs.

Also, using the search bar for this site and Python you will find many other samples and results.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-16 18:35:39 +0200

Seen: 36 times

Last updated: Jun 16