pyoo | PyOO allows you to control a running OpenOffice | Document Editor library
kandi X-RAY | pyoo Summary
kandi X-RAY | pyoo Summary
PyOO allows you to control a running OpenOffice or LibreOffice program for reading and writing spreadsheet documents
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
- Create a new label
- Convert a range of ranges into tuples
- Convert a CellRange to a box
- Create a new table
- Opens a spreadsheet
- Load an XComponent from a URL
- Create new index
- Creates a new spreadsheet
- The time in seconds
- Converts a number to a time
- Create a spreadsheet document
pyoo Key Features
pyoo Examples and Code Snippets
Community Discussions
Trending Discussions on pyoo
QUESTION
I am using pyoo to generate reports as open document spreadsheets. pyoo can do everything I require bar setting column widths. Some I want to set as a constant, others as optimal width. From the pyoo website (https://github.com/seznam/pyoo): "If some important feature missing then the UNO API is always available."
A few hours of Googling got me to the class com.sun.star.table.TableColumn which from this page appears to have the properties ("Width" and "OptimalWidth") that I require, but -
...ANSWER
Answered 2018-Apr-30 at 19:34Example Python-UNO code:
QUESTION
I have a program, that creates a CSV file.
Now I'd like to use a Python UNO script, which shall do several things:
1.) open the csv file in a spread sheet
2.) enable auto filter for all columns
3.) create a macro and add it to the document
4.) save the file as ODS file
This question concerns only 2.)
1.) is working
for 3.) I will probably create another question 1.) Is working (with pyoo and with unotools)
My steps so far:
I start manually:
...ANSWER
Answered 2017-Jan-13 at 16:05Here is code that uses straight PyUNO rather than a wrapper library. It is adapted from http://www.imaccanici.org/en.libreofficeforum.org/node/5413.html.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install pyoo
You can use pyoo like any standard Python library. You will need to make sure that you have a development environment consisting of a Python distribution including header files, a compiler, pip, and git installed. Make sure that your pip, setuptools, and wheel are up to date. When using pip it is generally recommended to install packages in a virtual environment to avoid changes to the system.
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page