[Dropped] Creating an ODS file with Python

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Locked
jody
Posts: 11
Joined: Sun Jun 22, 2008 3:40 pm

[Dropped] Creating an ODS file with Python

Post by jody »

I have a LibreOffice Basic script which i can start from within Calc with which i can select a zip file containing my CSV files and then load them into different sheets. This works well in Linux, but when i ported it to Windows it stopped working properly.
  • Is it possible to create a multi-sheet ODS calc document with a python script?
  • Is there perhaps an easy way to modify the ODS file of an empty calc document, so it will load my CSV files into separate sheets?
  • I see that LibreOffice provides for python scripts (Tools|Macros|Organize Macros...|Python ...) but all the buttons (especially "Create...) are disabled.
    • Is it possible to enable the python macros?
    • if yes how?
    • If so, is there a documentation on how to manipulate calc files from python ?
Last edited by MrProgrammer on Sun Aug 10, 2025 9:15 pm, edited 1 time in total.
Reason: Dropped: No attachment from jody
OOo 2.3.X on Fedora 8
User avatar
Zizi64
Volunteer
Posts: 11493
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Creating an ODS file with Python

Post by Zizi64 »

This works well in Linux, but when i ported it to Windows it stopped working properly.
Please upload your macro code here.
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.
Locked