Insert an object to excel by using python

Question

I want to add some object to my excel sheet, I'm using openpyxl, In excel you do it by: Insert->Object

Is there a way to do it thru openpyxl or any other excel tool that working with python?

http://stackoverflow.com/a/16408347/4044988 have a look on this answer. I hope it will help you — MegaBytes
– MegaBytes, Commented Apr 3, 2017 at 11:31

Charlie Clark · Accepted Answer · 2017-04-03 15:44:56Z

1

While this is not currently possible with openpyxl I suspect it would be fairly straightforward to add the relevant functionality using the add_image() method as a starting place.

answered Apr 3, 2017 at 15:44

Charlie Clark

19.7k4 gold badges56 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

anonymous · Accepted Answer · 2017-04-03 11:00:38Z

0

import openpyxl

wb = openpyxl.Workbook()
ws = wb.worksheets[0]

picture = openpyxl.drawing.Image('/path/to/picture')
picture.anchor(ws.cell('cell to put the image'))
ws.add_image(picture)

wb.save('whatever you want to save the workbook as')

This code of course refers to creating a new workbook and adding the image into it. To add the image to your preexisting workbook you would obviously just load that workbook using load_workbook.

answered Apr 3, 2017 at 11:00

anonymous

1431 gold badge2 silver badges16 bronze badges

1 Comment

Alex Zemtzov Over a year ago

I don't want to add image, I would like to add some "pdf" or "word" file

Collectives™ on Stack Overflow

Insert an object to excel by using python

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related