<a class="reference external image-reference" href="https://www.gnu.org/licenses/agpl"><img alt="License: AGPL-3" src="https://img.shields.io/badge/license-AGPL--3-blue.png" /></a> <a name="excel-report-engine-helpers"></a> <h2>Excel report engine helpers</h2> <p>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 <code>report_xls</code> module.</p> <a name="usage"></a> <h3>Usage</h3> <p>In order to create an Excel report you can:</p> <ul class="simple"> <li>define a report of type 'xlsx'</li> <li>pass <code>{'xlsx_export': 1}</code> via the context to the report create method</li> </ul> <p>The <code>AbstractReportXlsx</code> class contains a number of attributes and methods to facilitate the creation excel reports in Odoo.</p> <ul> <li><p class="first">Cell types</p> <p>string, number, boolean, datetime.</p> </li> <li><p class="first">Cell formats</p> <p>The predefined cell formats result in a consistent look and feel of the Odoo Excel reports.</p> </li> <li><p class="first">Cell formulas</p> <p>Cell formulas can be easily added with the help of the <code>_rowcol_to_cell()</code> method.</p> </li> <li><p class="first">Excel templates</p> <p>It is possible to define Excel templates which can be adapted by 'inherited' modules. Download the <code>account_move_line_report_xls</code> module from <a class="reference external" href="http://apps.odoo.com">http://apps.odoo.com</a> as example.</p> </li> <li><p class="first">Excel with multiple sheets</p> <p>Download the <code>account_asset_management_xls</code> module from <a class="reference external" href="http://apps.odoo.com">http://apps.odoo.com</a> as example.</p> </li> </ul> <a name="installation"></a> <h3>Installation</h3> <p>There is no specific installation procedure for this module.</p> <a name="configuration-and-usage"></a> <h3>Configuration and Usage</h3> <a class="reference external image-reference" href="https://runbot.odoo-community.org/runbot/143/10.0"><img alt="Try me on Runbot" src="https://odoo-community.org/website/image/ir.attachment/5784_f2813bd/datas" /></a> <a name="bug-tracker"></a> <h3>Bug Tracker</h3> <p>Bugs are tracked on <a class="reference external" href="https://github.com/OCA/reporting-engine/issues">GitHub Issues</a>. 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.</p> <a name="credits"></a> <h3>Credits</h3> <a name="contributors"></a> <h4>Contributors</h4> <ul class="simple"> <li>Luc De Meyer &lt;<a class="reference external" href="mailto:luc.demeyer&#64;noviat.com">luc.demeyer&#64;noviat.com</a>&gt;</li> </ul> <a name="maintainer"></a> <h4>Maintainer</h4> <a class="reference external image-reference" href="https://odoo-community.org"><img alt="Odoo Community Association" src="https://odoo-community.org/logo.png" /></a> <p>This module is maintained by the OCA.</p> <p>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.</p> <p>To contribute to this module, please visit <a class="reference external" href="http://odoo-community.org">http://odoo-community.org</a>.</p>