Excel report engine

v 6.1 Third Party 4193
Download for 6.1 series
You bought this module and need support ? Click here !
Technical name report_xls
Read description for v 10.0 v 9.0 v 8.0 v 7.0

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.

Please log in to comment on this module

Please choose a rating from 1 to 5 for this module.