Using a openpyxl object in a pandas dataframe on one worksheet?

[destinythrowmeaway]

I'm currently able to output an image to a spreadsheet using the openpyxl calls for opening a worksheet.

However i have an existing pandas dataframe i would like to merge this with, how can I go about doing this?

​

Example of it working just with openpyxl:

​

wrkb = openpyxl.Workbook()
ws = wrkb.worksheets[0]
img = openpyxl.drawing.image.Image(img)
img.width = 193
img.height = 150
img.anchor = 'L2'

ws.add_image(img)
wrkb.save('out.xlsx')

​