Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
3 Replies
13101 Tampilan

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
Buang
Jawaban Terbai

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
Buang
Jawaban Terbai

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
Buang
Jawaban Terbai

thank you Niyas but how to resize image ?

Avatar
Buang

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

Post Terkait Replies Tampilan Aktivitas
1
Agu 24
2089
6
Sep 22
27793
1
Apr 19
2819
7
Apr 19
14703
2
Mei 18
5669