Skip to content

Latest commit

 

History

History
 
 

report_xls

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
i18n
i18n
 
 
static/description
static/description
 
 
README.rst
README.rst
 
 
__init__.py
__init__.py
 
 
__openerp__.py
__openerp__.py
 
 
ir_report.py
ir_report.py
 
 
report_xls.py
report_xls.py
 
 
utils.py
utils.py
 
 

README.rst

License: AGPL-3

Excel report engine

This module adds Excel export capabilities to the standard odoo reporting engine.

Usage

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 OpenERP.

  • 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 OpenERP Excel reports.

  • cell formulas

    Cell formulas can be easily added with the help of the rowcol_to_cell() function which you can import from the utils.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.

Bug Tracker

Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us smashing it by providing a detailed and welcomed feedback.

Credits

Contributors

  • Noviat

Maintainer

Odoo Community Association

This module is maintained by the OCA.

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

To contribute to this module, please visit https://odoo-community.org.