Skip to Content
This question has been flagged
reportexcelimages
3 Replies
16558 डेटा देखने का तरीका
अवतार
skh-openerp

Hello Folks,


I have been creating an excel report, and want to use product images into the same report. I have used the code: worksheet.insert_image(stat_row+1, 0, order_line.product_id.image_small, {'x_scale': 0.9, 'y_scale': 0.6}) to insert the image into excel sheet created. But it fails to insert the image.


Can anyone helps me to know the same? I have many order lines for my sales orders and want images for all the products.


Many thanks in advance.

अवतार
खारिज करें
अवतार
Niyas Raphy (Walnut Software Solutions)
Best Answer

Hi,

You can add the images to excel report like this,

if product.image_medium:
    product_image = io.BytesIO(base64.b64decode(product.image_medium))
    sheet.insert_image(row, col, "image.png", {'image_data': product_image})

Thanks

अवतार
खारिज करें
अवतार
LeafByte, LeafByte
Best Answer

Checkout our module which is available on Odoo Apps with Version 14, 15 and 16.

Search on Odoo apps Module name: Add Image in Excel / xls report

अवतार
खारिज करें
अवतार
***TEST***
Best Answer

thank you Niyas but how to resize image ?

अवतार
खारिज करें
Raghupathy.k

sheet.insert_image('B1', product_image, {'x_scale': 0.6, 'y_scale': 0.8})

Related Posts Replies डेटा देखने का तरीका ऐक्टिविटी
Odoo 14 to Odoo 18 Migration Issue – Aged Partner Balance Report
report excel
अवतार
अवतार
अवतार
2
मई 26
804
How to add a total row at the end of Excel report in Odoo ?
report excel
अवतार
अवतार
अवतार
अवतार
3
अप्रैल 26
1245
Subtraction in Excell report ODOO 12
report excel Odoo12
अवतार
अवतार
1
अग॰ 24
4445
How to download .xls file in a single click? Solved
report excel python2.7
अवतार
अवतार
अवतार
अवतार
अवतार
6
सित॰ 22
31153
Error On Saving Excel Report in Odoo V12c
report excel odooV12
अवतार
अवतार
1
अप्रैल 19
5328