Ask Your Question

Revision history [back]

I want to export 50 Calc files to csv files . Doing this manually takes a long time.

With Unoconv you can do that on a POSIX shell like this:

unoconv -f csv the-folder-with-the-50-calc-files/*.ods

Using his code I can launch the Python shell and connect to LibreOffice. He does not show how to open a specific Calc file.

If it for some reason is a requirement for you to use Python, give these PyUNO examples a look. It looks like it would be fairly simple to add CSV export to the ooextract.py example which extracts plaintext, HTML or PDF.

I want to export 50 Calc files to csv files . Doing this manually takes a long time.

With Unoconv you can do that on a POSIX shell like this:

unoconv -f csv the-folder-with-the-50-calc-files/*.ods

(I'm not familiar enough with Windows shell to know if that works, but from what I can read, it seams to support globbing, e.g. the *. Otherwise Busybox for Windows inculdes a POSIX shell. Someone who knows Windows may have more of a clue here.)

Using his code I can launch the Python shell and connect to LibreOffice. He does not show how to open a specific Calc file.

If it for some reason is a requirement for you to use Python, give these PyUNO examples a look. It looks like it would be fairly simple to add CSV export to the ooextract.py example which extracts plaintext, HTML or PDF.