Excel中的Odoo图像 [英] Odoo image in excel

问题描述

我正在用xlsxwriter创建一个excel文件，需要将公司徽标放入这些excel文件中. 我想那有点像将partner.image解析到缓冲区中……但是我卡住了. 这是我的代码.

I'm creating an excel file with xlsxwriter and need to place my company logo into these excel file.. I've been trying with insert_image but not success. I suppose that is something like parse partner.image into a buffer... but im stuck.. Pleace your help. this is my code.

  @api.multi
def report_print(self):
    output=io.BytesIO()
    book=xlsxwriter.Workbook(output)

    sheet1=book.add_worksheet("PCA")
    sheet1.write('A1','PCA')
    #=======================================================================
    # Looking for partner data
    #=======================================================================
    user=self.env['res.users'].browse(self.env.uid)
    partner = self.env['res.partner'].browse(user.company_id.id)

    #copy partner name in B1
    partner_name = partner.name
    sheet1.write("B1",partner_name) 


    #put partner logo in B3
    buf_image=io.BytesIO(partner.image)
    sheet1.insert_image('B3',base64.b64encode(buf_image.getvalue()),{'image_data': buf_image})

    book.close()

    self.write({
        'file':base64.b64encode(output.getvalue())})

推荐答案

在Odoo v11中，我使用:

In Odoo v11 I use :

buf_image=io.BytesIO(base64.b64decode(partner.image))
sheet1.insert_image('B3', "any_name.png", {'image_data': buf_image})

这篇关于Excel中的Odoo图像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！