当我尝试将python中url中的图像插入excel时，出现错误“强制转换为Unicode:需要字符串或缓冲区，cStringIO.StringO找到”。

Question

我试图从一个url向excel中插入一个图像，但是我得到了这个错误：

coercing to Unicode: need string or buffer, cStringIO.StringO found

下面是我的代码：

import cStringIO
from PIL import Image
import urllib

wb = pyExcelerator.Workbook()
ws = wb.add_sheet('sheet 1')
url= 'this url contains the url of an image'

f = urllib.urlopen(url)
buf = f.read()
fileIO = cStringIO.StringIO(buf)
img = Image.open(fileIO).convert("RGB")
img.thumbnail((71, 100), Image.ANTIALIAS)
img_bmp = cStringIO.StringIO()
img.save(img_bmp, 'BMP')
img_bmp.seek(0)
ws.insert_bitmap(img_bmp, 0, 1)

Answer 1

我必须保存图像并将其转换为bmp。

import cStringIO
from PIL import Image
import urllib

wb = pyExcelerator.Workbook()
ws = wb.add_sheet('sheet 1')
url= 'this url contains the url of an image'
dir= 'It is a directory location'

f = urllib.urlopen(url)
buf = f.read()
fileIO = cStringIO.StringIO(buf)
img = Image.open(fileIO).convert("RGB")
img.thumbnail((71, 100), Image.ANTIALIAS)
img_bmp = cStringIO.StringIO()

#this is the one that converts the image to bmp
img.save(img_bmp, 'BMP') 

with open('{}/prova_img.bmp'.format(dir), 'w') as file_handle:
    file_handle.write(img_bmp.getvalue())

ws.insert_bitmap('{}/the_bitmap_image.bmp'.format(dir), 0, 1)