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.