Excel report engine

Technical Name:
  • Odoo Version

Excel report engine

This module adds Excel export capabilities to the standard OpenERP 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 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.openerp.com as example.

  • XLS with multiple sheets

    Download the account_journal_report_xls module from http://apps.openerp.com as example.

Development assistance

Contact info@noviat.com for help with the development of Excel reports in OpenERP.

This is a preview of the recently viewed products by the user.
Once the user has seen at least one product this snippet will be visible.

Recently viewed Products