Excel report engine
by Noviat http://www.noviat.com , Odoo Community Association (OCA) http://www.noviat.com
Odoo
Availability |
Odoo Online
Odoo.sh
On Premise
|
Technical Name |
report_xls |
License | AGPL-3 |
Website | http://www.noviat.com |
Excel report engine
This module adds Excel export capabilities to the standard odoo reporting engine.
Report development
In order to create an Excel report you can
- define a report of type 'xls'
- pass
{'xls_export': 1}
via the context to the report create method
The report_xls
class contains a number of attributes and methods to facilitate the creation XLS reports in odoo.
-
cell types
Supported cell types : text, number, boolean, date.
-
cell styles
The predefined cell style definitions result in a consistent look and feel of the odoo Excel reports.
-
cell formulas
Cell formulas can be easily added with the help of therowcol_to_cell()
function which you can import from theutils.py
module.
-
Excel templates
It is possible to define Excel templates which can be adapted by 'inherited' modules.
Download the account_move_line_report_xls module from http://apps.odoo.com as example.
-
XLS with multiple sheets
Download the account_journal_report_xls module from http://apps.odoo.com as example.
Development assistance
Contact info@noviat.com for help with the development of Excel reports in odoo.
Please log in to comment on this module