Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
reportexcelimages
3 Odgovori
13702 Prikazi
Avatar
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.

Avatar
Opusti
Avatar
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

Avatar
Opusti
Avatar
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

Avatar
Opusti
Avatar
***TEST***
Best Answer

thank you Niyas but how to resize image ?

Avatar
Opusti
Raghupathy.k

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

Related Posts Odgovori Prikazi Aktivnost
Subtraction in Excell report ODOO 12
report excel Odoo12
Avatar
Avatar
1
avg. 24
2571
How to download .xls file in a single click? Solved
report excel python2.7
Avatar
Avatar
Avatar
Avatar
Avatar
6
sep. 22
28368
Error On Saving Excel Report in Odoo V12c
report excel odooV12
Avatar
Avatar
1
apr. 19
3319
How to create Excel report in odoo9 ? Solved
report excel odoo9
Avatar
Avatar
Avatar
Avatar
7
apr. 19
15166
Rml Report to Excel Report
rml report excel
Avatar
Avatar
Avatar
2
maj 18
5967