Python Excelwriter (xlsxwriter) 从 URL 插入图像

Question

如何使用 xlswriter 插入来自 URL (http) 的图像？这是来自文档:

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

或

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

但这仅适用于文件路径。我想从 Web 服务器的 URL 添加图像。你能帮忙吗？

Answer 1

# Read an image from a remote url.
url = 'https://raw.githubusercontent.com/jmcnamara/XlsxWriter/' + \
      'master/examples/logo.png'

image_data = BytesIO(urllib2.urlopen(url).read())

# Write the byte stream image to a cell. Note, the filename must be
# specified. In this case it will be read from url string.
worksheet.insert_image('B2', url, {'image_data': image_data})

http://xlsxwriter.readthedocs.io/example_images_bytesio.html