xlsxwriter insert_image .insert_image

Question

I want to insert an image to Excel document, and I try to use xlsxwriter insert_image, but it said unknown.insert_image.

      from win32com import client
        xlApp = client.Dispatch("Excel.Application")
        workbook = xlApp.Workbooks.Open('test.xlsx')
        worksheet = workbook.Worksheets[0]
        worksheet.insert_image('F4','logo.png')
        worksheet.Visible = 1
        worksheet.ExportAsFixedFormat(0, 'D:\\Python\\whatever\\test.pdf')
        workbook.close()

it raised

Exception "unhandled AttributeError" unknown.insert_image

This is an example for xlsxwriter. http://xlsxwriter.readthedocs.io/example_images.html — bilbo_strikes_back, Jun 19 '17 at 15:53

score 0 · Accepted Answer · answered Jun 20 '17 at 09:21

0

You are mixing 2 incompatible objects in this example client.Dispatch("Excel.Application").Workbooks.Open('name') and xlsxwriter.Workbook.

You need to use the equivalent method to xlsxwriter.worksheet.insert_image() in the other object/class.

Maybe try the syntax from this answer.

answered Jun 20 '17 at 09:21

jmcnamara

38,196
6
90
108

thank you for your suggestion, and finally I use openpyxl to replace – Javier Zhang Jun 29 '17 at 13:51

xlsxwriter insert_image .insert_image

1 Answers1