python method in libreoffice calc

[leesmithUCSB]

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.

lee

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.

[Ratslinger]

Hello,

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.