Skip to Content

XLSX Report Generator

by
Odoo
v 16.0 Third Party 255
Download for v 16.0 Deploy on Odoo.sh
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 379
Technical Name alnas_xlsx
LicenseLGPL-3
Websitehttps://github.com/alienyst
Versions 14.0 16.0 17.0 18.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 379
Technical Name alnas_xlsx
LicenseLGPL-3
Websitehttps://github.com/alienyst
Versions 14.0 16.0 17.0 18.0

Xlsx Report Generator

The Xlsx Report Generator is a module that helps you create reports using only a .Xlsx template and Jinja syntax.

This module inspired from Report Xlsx.

Prerequisites

Before installing this module, make sure to install the following libraries:

  • pip install xlsxtpl num2words Babel

Usage

For usage instructions, you can refer to the following video: Link

Video Preview

Documentation on xlsxtpl syntax in the document: https://pypi.org/project/xlsxtpl


You can see example template for sale order here : https://github.com/alienyst/alnas-xlsx/raw/16.0/alnas_xlsx/static/description/example/example.xlsx


Field Naming Convention

To call and write the field name, use the following format: {{docs.field_name}}, starting with the word "docs".

Useful Functions (Indonesian Language as default)

  • {{spelled_out(docs.numeric_field)}}: Spell out numbers
  • {{formatdate(docs.date_field)}}: Format dates

Note: The functions will be updated as needed.

lang default is lang='id_ID' change if need, example = {{spelled_out(docs.numeric_field, lang='en_US')}}

Feedback

We welcome any feedback and suggestions, especially for improving this module. Thank you!

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.
There are no ratings yet!
by
Hector Isaias Linares Ramirez
on 7/10/24, 1:09 PM 
Traceback (most recent call last):
  File "/home/odoo/src/user/alnas_xlsx/controllers/report_controller.py", line 59, in report_download
    response = self.report_routes(
  File "/home/odoo/src/odoo/odoo/http.py", line 716, in route_wrapper
    result = endpoint(self, *args, **params_ok)
  File "/home/odoo/src/user/alnas_xlsx/controllers/report_controller.py", line 34, in report_routes
    xlsx_files, file_type = report.with_context(**context)._render_jinja_xlsx(reportname, docids, data=data)
  File "/home/odoo/src/user/alnas_xlsx/models/ir_actions_report.py", line 47, in _render_jinja_xlsx
    "parsehtml": self._parse_html,
AttributeError: 'ir.actions.report' object has no attribute '_parse_html'


Re:
by
Li Changyu
on 7/10/24, 10:20 PM Author

Hello,

Thank you for your feedback. I apologize for the confusion. I forgot to rescan the repository. Please download it again.

If you encounter any other issues or need further assistance, please don't hesitate to let me know.

Best regards, Li


[ISSUE] Invalid Method
by
James Nguyen
on 6/28/24, 9:15 PM

Hi, I checked Python Code, Method '_parse_html' does not exist.
Please check your python code.

Re: [ISSUE] Invalid Method
by
Li Changyu
on 6/30/24, 12:43 AM Author

Hi,

Thank you for your feedback. I have reviewed the code and noticed that the _parse_html method was indeed referenced but not defined. I have since removed the code that calls _parse_html.

Please let me know if there are any other issues or if you need further assistance.

Best regards, Li