How to insert image into the excel report?

Question

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) · Accepted 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 · 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*** · Answer

thank you Niyas but how to resize image ?

関連投稿	返信	ビュー
Subtraction in Excell report ODOO 12 report excel Odoo12	1 8月 24	2570
How to download .xls file in a single click? 解決済 report excel python2.7	6 9月 22	28365
Error On Saving Excel Report in Odoo V12c report excel odooV12	1 4月 19	3315
How to create Excel report in odoo9 ? 解決済 report excel odoo9	7 4月 19	15162
Rml Report to Excel Report rml report excel	2 5月 18	5965

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！