Hello people
I would like to use information from an ods file different from the one the macro runs in.
My question is a bit like Macro to open a document & read the first line of text - #2 by PYS, but with the macro written in Python
I’ve tried to import pandas_ods_reader but, unsurprisingly, it doesn’t work.
Please, tell we more context.
Need you open the files first?, need you copy format or only data?
For open documents:
https://wiki.documentfoundation.org/Macros/Python_Guide/Documents
Copy content cell from Spreadsheet to other.
https://wiki.documentfoundation.org/Macros/Calc/py001
Why do you need pandas for this? As you linked yourself, all you need is to use the available api, wich is the same for Python and Basic.
.
I’d use pandas, if I’m outside libre-office not, if this is/will be a macro inside LO.
The Docs Append and Impress append Slides to existing slide show examples on Live LibreOffice Python UNO Examples both get data from another file. Perhpas it might be useful examples for your needs.
Thanks, I was not aware it was the same API