Excel report engine

by
Odoo
v 6.1 v 7.0 Third Party 4221
Download for v 6.1
Technical Name report_xls
LicenseAGPL-3
Websitehttp://www.noviat.com
Repositorylp:~noviat/openobject-addons/extra-6.1
Also available in version v 7.0
You bought this module and need support? Click here!

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

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.