Python Excel Writer xlswriter Insert Image from URL

Question

How can I insert an image from the URL (HTTP) with xlswriter? This is from the documentation:

worksheet.insert_image('B2', 'python.png')

or

worksheet1.insert_image('B10', '../images/python.png')

But this is only for the file path. I want to add an image from a URL from a Web Server. Can you help?

Answer 1

Use this:

url = "..../picture.jpg"
data = urllib.request.urlopen(url).read()
file = open("image.jpg", "wb")
file.write(data)
file.close()
worksheet.insert_image('B2', 'image.jpg')