Search 1.4 billion lines of Odoo code on GitHub

report_xlsx_helpers

Author: Noviat,Odoo Community Association (OCA)
License: AGPL-3
Branch: 10.0
Repository: akretion/noviat-apps
Dependencies: report_xlsx
Languages: Python (309, 85.8%), and reStructuredText (51, 14.2%)
Other branches: 10-improve-zero_cancel
Other repositories: Bubbles-IT/noviat-apps, DudhatShivam/noviat-apps, FullBringEc/noviat-apps, Guobower/noviat-apps, Idealisconsulting/noviat-apps, PieterPaulussen/noviat-apps, SetRac/noviat-apps, brain-tec/noviat-apps, cameroun/noviat-apps, coopaname/noviat-apps, eezee-it/noviat-apps, francislouie/noviat-apps, gfcapalbo/noviat-apps, johanvhg/noviat-apps, luc-demeyer/noviat-apps, marionumza/noviat-apps, markrobinson85/noviat-apps, odoo-modules/noviat-apps, sasakuma/noviat-apps, sunflowerit/noviat-apps, suningwz/noviat-apps, van-orsouw-consultancy/noviat-apps, and vidtsin/noviat-apps

License: AGPL-3

Excel report engine helpers

DEPRECATED (renamed to report_xlsx_helper).

This module provides a set of tools to facilitate the creation of excel reports with format xlsx. This module offers a similar functional coverage as the 8.0 version of the report_xls module.

Usage

In order to create an Excel report you can:

  • define a report of type 'xlsx'
  • pass {'xlsx_export': 1} via the context to the report create method

The AbstractReportXlsx class contains a number of attributes and methods to facilitate the creation excel reports in Odoo.

  • Cell types

    string, number, boolean, datetime.

  • Cell formats

    The predefined cell formats result in a consistent look and feel of the Odoo Excel reports.

  • Cell formulas

    Cell formulas can be easily added with the help of the _rowcol_to_cell() method.

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

  • Excel with multiple sheets

    Download the account_journal_report_xlsx module from http://apps.odoo.com as example.

Installation

There is no specific installation procedure for this module.

Configuration and Usage

Try me on Runbot

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

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 http://odoo-community.org.