XLSX Report Generator

Prerequisites

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

• pip install xlsxtpl

Installation

To install this module:

1. Download the module and place it in Odoo Custom Addons folder.
2. Restart Odoo Server
3. Go to Odoo UI and Enable Debug Mode then open the Apps menu.
4. Refresh the list by clicking Update Apps List. Finally, you will see Xlsx Report Generator module and click the Install button.

Usage

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

For example template

1. Sale Order: https://github.com/alienyst/alnas-xlsx/raw/16.0/alnas_xlsx/static/description/example/example.xlsx
2. Sale Order with Image Replace: https://github.com/alienyst/alnas-xlsx/raw/16.0/alnas_xlsx/static/description/example/example_with_picture.xlsx
3. Sale Order with Insert Image: https://github.com/alienyst/alnas-xlsx/raw/16.0/alnas_xlsx/static/description/example/example_with_picture_insert.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)

• {% xv docs.date_field %}: Non-string value for a cell to to specify a variable
• {% yn docs.boolean_field %}: return a checkbox base on boolean condition
• {{ spelled_out(docs.numeric_field) }}: Spell out numbers
• {{ formatdate(docs.date_field) }}: Format dates
• {{ convert_currency(docs.monetary_field, docs.currency_id) }}: Format monetary field
• {% insert_img docs.image_field %}: Insert image in cell *(image fit to sel)
• {% insert_img_cell docs.image_field %}: Insert image in cell *(cell fit to image)
• {% insert_img_cell docs.image_field, width=200, height=200 %}: Insert image in cell *(custom image size)
• {% img docs.image_field %}: Replace dummy image with image field, *require dummy image in template
• 

Notes

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