Menu
I have an spreadsheet-based automated report that needs to be created daily, with some charts, aggregating functions (e.g. SUM and AVERAGE) and formatted cells (Dates, percentage, etc.).
I have tried to write these results directly to an Excel file, but Python's xlwt and xlrd don'y support charts and functions.
Moreover, trying to open an existing, formatted Excel file and changing some cell's values ended up erasing all charts and functions in the existing file.
Is there a way to write charts and functions to an OpenOffice spreadsheet, or at least change cells in an existing spreadsheet without erasing data? If there is a Pythonic way to do it, I can easily convert the OO file into an Excel file and deliver it.
554
Openpyxl is a Python library that provides various methods to interact with Excel Files using Python. It allows operations like reading, writing, arithmetic operations, plotting graphs, etc.
Select the cell where the upper left-hand cell of the external data is to be inserted. Choose Insert > Link to External Data. On the External Data dialog, type the URL of the source document or click the [...] button to open a file selection dialog.
The solution to storing all your numbers and lists! Calc is the spreadsheet application you've always wanted. Newcomers find it intuitive and easy to learn; professional data miners and number crunchers will appreciate the comprehensive range of advanced functions.
You can use PyUNO, a Python library to use UNO API.
Here is a Python example to do some manipulations in a Calc document.
89
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
