Rocker Reporting Application
for Odoo 17 / Odoo16 / Odoo 15 / Odoo 12.0 / Odoo 13.0 / Odoo 14.0
Collect data to single Excel from various data sources, Use Excel templates to present business graphs. Combine data with Excel Power Pivot. Get data from Odoo & external PostgreSQL, SQLAlchemy, SQLServer, MySQL, MariaDB, ODBC or Oracle databases.
News/Notes:
- 3.2.2024
Rocker Reporting for Odoo 17
SQLAlchemy drivers supported
- 19.9.2023
Rocker Reporting for Odoo 16
Look installation guide how to get rid of: Excel Access denied error or Excel SaveAs error
- 15.10.2021
Rocker Reporting for Odoo 15 is ready.
Runs well even if Odoo 15 is a windows service - 15.2.2021
At the moment we have a problem starting Excel if Odoo runs as a service.
Everything works well if you start Odoo from command prompt. See install guide in docs folder.If someone knows the solution to: excel = win32.gencache.EnsureDispatch('Excel.Application') causing (-2147023584, 'A specified logon session does not exist. It may already have been terminated.', None, None) error, pls email.
Openpyxl version https://apps.odoo.com/apps/modules/14.0/rocker_app/ does not have a problem but this one supports all Excel 2016 features including Power Pivot
Author contact: antti.rocker.karki@outlook.com
Requirements:
- Odoo 12, 13, 14,15, 16, 17 installed on Windows platform
- Excel 32 bit installed on server
- Datasource drivers (PostgreSQL, SQLAlchemy, SQLServer, Oracle, MySQL, MariaDB etc.) installed on server based on your needs
Examples:
-
Powerpoints: Powerpoint table slide
-
Powerpoints: Powerpoint Column Chart slide
-
Powerpoints: Powerpoint Pie Chart slide
-
Powerpoints: Powerpoint Collection
-
Rocker Excel example: Data from single datasource
-
Rocker Excel example: Collection reports, data from many datasources
Guides:
- Install guide
Please log in to comment on this module