52.How To Create Excel Report In Odoo 14 || Excel Reporting in Odoo || Base Report XLSX Odoo 14

[@ivanespinosa9104]

Excellent tutorial! but I have a question, a date field that I have in my module at the time the excel report appears, the box appears with #### instead of the date corresponding to a record, how do I change the #### for the date?

[@OdooMates]

You have crested this excel reports?

[@ivanespinosa9104]

@@OdooMates I already created my own excel report, but I already solved it, very good video

[@OdooMates]

Glad to hear it ❤️

[@smsmzean759]

Excellent tutorial!

[@OdooMates]

Glad you liked it!

[@marwael-sherif6928]

When try t install report xlsx module I have the following exception: ValueError: ir.actions.report.report_type: required selection fields must define an ondelete policy that implements the proper cleanup of the corresponding records upon module uninstallation. Please use one or more of the following policies: 'set default' (if the field has a default defined), 'cascade', or a single-argument callable where the argument is the recordset containing the specified option

[@OdooMates]

seems you are trying to install old version of report_xlsx in odoo14. Can you download v14 of report_xlsx and then install it

[@domza001]

You have VDO educate install in window 10 ?, where is developer mode

[@OdooMates]

we haven't made any videos in windows yet, if you are looking for how to activate the developer mode, you can go to settings menu, there you can see the option to activate the developer mode

[@SamirSELLAMI]

Great tutorial ! Can you plz provide tutorials on how to mail merge an Odoo model into .odt or .docx office template ?

[@OdooMates]

Are you looking for how to export record in these formats?

[@SamirSELLAMI]

@@OdooMates I mean using a prepared .odt template to generate an Odoo report in various format pdf, doc, etc. Something like “Py3o Report Engine” from the OCA.

[@muneebhaider5861]

Hi 'Format' object has no attribute 'set_bg-color' this error shows up when i put 'bg-color' : 'yellow' in the format otherwise it works fine. Any solution? Thank you

[@OdooMates]

which version ?

[@muneebhaider5861]

@@OdooMates odoo 13

[@ember209]

Hello, I get raise "UnsupportedImageFormat( xlsxwriter.exceptions.UnsupportedImageFormat: image.png: Unknown or unsupported image file format" while generating an excel file with a pic. I tried image.jpg and image.jpeg but it did not help. What might be the source of problem?

[@rafwenger]

Thanks Niyas for this great video! Could you please explain how can I email such xlsx report using a scheduled action? Thanks!

[@huzaifaelnaeem2636]

how can we add fields,menu,... from Odoo 14 based to our module? please provide video for it as u said .

[@OdooMates]

For adding Menu and Action: kzbin.info/www/bejne/gXe7oJh7r9yrsLM For adding View: kzbin.info/www/bejne/rGG0n2B-gNmcqJo

[@huzaifaelnaeem2636]

@@OdooMates I already watched this,i mean exactly inheritance .

[@OdooMates]

@@huzaifaelnaeem2636 can you elaborate little more brother

[@huzaifaelnaeem2636]

@@OdooMates why if we want to inherit odoo based(fields,...)--> it's appear in odoo based module instead to our model form or list. I've a little doubt since i am coming form java background.

[@OdooMates]

@@huzaifaelnaeem2636 sorry to say that we didnt get the question correctly, if still it is not resolved and looking for solution, can you elaborate further with an example of res.partner model

[@sabrianass2721]

Hello, First, thank you very much for the tutoriel, I followed all the steps, but when I click on "print", then on "Patient Card Excel" nothing happens : no error and no generation of the excel report. Any solutions please?

[@OdooMates]

can you compare the code with the code here: apps.odoo.com/apps/modules/14.0/om_hospital/

[@ashaAhmed-hi5yl]

I working with enterprise version i didn't found report_xlsx module only found test xlsx export

[@OdooMates]

you have to download the module from oca github or from odoo apps and then add it your odoo instance

[@OdooMates]

apps.odoo.com/apps/modules/14.0/report_xlsx/

[@ashaAhmed-hi5yl]

@@OdooMates ok thanks

[@OdooMates]

@@ashaAhmed-hi5yl welcome

[@medvallelhadjsidi390]

hello, when I create an excel report the generation of the pdf report was unsuccessful

[@OdooMates]

what error is coming ?

[@medvallelhadjsidi390]

@@OdooMates nothing , but just in the pycharm I saw "GET /web/static/image/placeholder.png HTTP / 1.1" 304 - - - -

[@medvallelhadjsidi390]

when I go back to the sales module again pdf generation it does not work

[@OdooMates]

so you are creating excel report for the sale order and default sale order pdf getting failed ?

[@medvallelhadjsidi390]

@@OdooMates it does not work in the sales module

[@OdooMates]

Let me know how you coded it

[@medvallelhadjsidi390]

@@OdooMates I created a directory that I named report in which I put two report.xml file with its content and patient_card.xml contains my template and I put their path in the manifest.xml file

[@OdooMates]

@@medvallelhadjsidi390what is the error you get. share your code and error message to [e-mail]

[@MuhammedMushraf-h2b]

ValueError: Wrong value for ir.actions.report.report_type: 'xlsx' i gert this error whwn upgrading the module

[@OdooMates]

did you add report_xlsx module to your instance and add dependency in your module ?

[@parulsharma7474]

when i print invoice_line_ids in excel report , i got 4 extra fields, and i hide these field using condition , but now it showing blank cell, how can i reduce these blank cells in excel

[@OdooMates]

can you show us the written code

[@parulsharma7474]

@@OdooMates how can i show you,your mail id?

[@OdooMates]

[e-mail] or you can share relevant part of the codes here as comment too

[@parulsharma7474]

@@OdooMates i mailed you plz check

[@parulsharma7474]

@@OdooMates from odoo import models import datetime from datetime import datetime, timedelta, date import re from odoo.exceptions import ValidationError class PartnerXlsx(models.AbstractModel): _name = 'report.extrainfo.report_hsn_report' _inherit = 'report.report_xlsx.abstract' def generate_xlsx_report(self, workbook, data, partners): sheet = workbook.add_worksheet('HSN REPORT') bold = workbook.add_format({'bold': True}) format1 = workbook.add_format({'bold': True, 'align': 'left'}) todays_date = date.today() today_date = date.today() - timedelta(1) row = 0 col = 0 sheet.write(row, col + 0, 'HSN', format1) sheet.write(row, col + 1, 'Description', format1) sheet.write(row, col + 2, 'UQC', format1) sheet.write(row, col + 3, 'Total Quantity', format1) sheet.write(row, col + 4, 'Total Value', format1) sheet.write(row, col + 5, 'Rate', format1) sheet.write(row, col + 6, 'Taxable Value', format1) sheet.write(row, col + 7, 'Integrated Tax Amount', format1) sheet.write(row, col + 8, 'Central Tax Amount', format1) sheet.write(row, col + 9, 'State/UT Tax Amount', format1) sheet.write(row, col + 10, 'Cess Amount', format1) for obj in partners: for rec in data['partner_id']: row += 1 res = rec.get('partner_id') domain = [] res_partnerId = self.env['account.move'].sudo().search([('partner_id', '=', res[0])]) actual_item = [] abc_id = self.env['account.move.line'].sudo().search([('move_id', '=', 8)]) data = self.env['product.product'].sudo().search_read(domain) # print("@@@@@@@@@@@@@@@@@@@@@@@@@@@@", real_item) for y in abc_id: row += 1 if y['total_amount'] == 0: sheet.write(row, col," ") else: sheet.write(row, col, y['hsnsac']) if y['total_amount'] == 0: sheet.write(row, col + 1, " ") else: sheet.write(row, col + 1, y['name']) if y['total_amount'] == 0: sheet.write(row, col + 2, " ") else: sheet.write(row, col + 2, y['uom']) if y['total_amount'] == 0: sheet.write(row, col+3," ") else: sheet.write(row, col + 3, y['quantity']) if y['total_amount'] == 0: sheet.write(row, col+4," ") else: sheet.write(row, col + 4, y['total_amount']) if y['total_amount'] == 0: sheet.write(row, col+5," ") else: sheet.write(row, col + 5, y['price_unit']) if y['total_amount'] == 0: sheet.write(row, col+6," ") else: sheet.write(row, col + 6, y['price_subtotal']) if y['total_amount'] == 0: sheet.write(row, col + 8, " ") elif (y['tax_ids'] == "GST 1%", "GST 5%", "GST 12%", "GST 18%", "GST 28%"): sheet.write(row, col + 8, y['tax_value'] / 2) else: sheet.write(row, col + 8,"yes") if y['total_amount'] == 0: sheet.write(row, col + 9, " ") elif (y['tax_ids'] == "GST 1%", "GST 5%", "GST 12%", "GST 18%", "GST 28%"): sheet.write(row, col + 9, y['tax_value']/2) else: sheet.write(row, col + 9, "no") if y['total_amount'] == 0: sheet.write(row, col + 7, " ") elif (y['tax_ids'] == "IGST 1%", "IGST 5%", "IGST 12%", "IGST 18%", "IGST 28%"): sheet.write(row, col + 7, y['tax_value']) else: sheet.write(row, col + 7, "no") check this

[@NuredinMuhamed-g8g]

is it base report xlsx work for v17 odoo 17?

[@OdooMates]

yes, you can download v17 of that

[@vajidap3903]

how to print a one2many in excel

[@OdooMates]

By iterating over a for loop

[@vajidap3903]

@@OdooMates can you do a video please

[@bereketoldema6877]

how to install xlsxwriter and xlrd module , it's not working for me

[@OdooMates]

pip install XlsxWriter

[@Anjalisharma-zj8ce]

when i use, search_read in my code it through 'name' error, code is- p_id = self.env['partner.loan.details'].search_read(domain) what should i do

[@thaoo99]

^^ thanks

[@OdooMates]

welcome

[@thaoo99]

@@OdooMates can you give me the solution to do this? how to create field: date, type : datetime with autofill with today's date and default 00:00 time, thanks ^^

[@OdooMates]

@@thaoo99 date_from = fields.Date(string='Start Date', default=date.today(), required=True)

[@thaoo99]

@@OdooMates

[@OdooMates]

@@thaoo99 welcome