使用python在单元格Excel中填充图像 [英] Fill a image in a cell excel using python
本文介绍了使用python在单元格Excel中填充图像的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试使用适用于python的openpyxl模块将经过调整大小的照片添加到excel文件中,我正在使用以下代码,但是没有起作用...仅从指定的单元格添加了照片(未调整大小).
I am trying to add a resized photo into a excel file using openpyxl module for python i am using the following code but didnt work... only adds the photo (not resized) from the specified cell.
import openpyxl
from openpyxl import load_workbook
from openpyxl import Workbook
wb = load_workbook('file.xlsx')
ws = wb.active
img = Image.open('photo.jpg')
nimg = img.resize((140,92))
img=openpyxl.drawing.image.Image('photo.jpg')
ws.add_image(img, 'F2') #where F2 is the cell where i want to add the photo
wb.save('test.xlsx')
我也尝试用PIL打开图像,但是当我想将调整大小后的图像作为参数时,我会遇到一些错误.
I also tried to open the image with PIL but when i want to give the resized image as a parameter i`ve got some errors..
import openpyxl
from PIL import Image
from openpyxl import load_workbook
from openpyxl import Workbook
wb = load_workbook('file.xlsx')
ws = wb.active
img = Image.open('photo.jpg')
nimg = img.resize((140,92))
final=openpyxl.drawing.image.Image(nimg) #i think here i got some errors
ws.add_image(final)
wb.save('test.xlsx')
Traceback (most recent call last): File "C:/Users/uidn4858/Desktop/Task2/sc.py", line 29, in <module> new=openpyxl.drawing.image.Image(nimg, 'F2') File "C:\Python27\lib\site-packages\openpyxl-2.4.9-py2.7.egg\openpyxl\drawing\image.py", line 54, in __init__ self.format = image.format.lower() AttributeError: 'NoneType' object has no attribute 'lower'
推荐答案
import openpyxl
from openpyxl import load_workbook
from openpyxl import Workbook
from PIL import Image
width = 23
height = 23
img = Image.open('photo.jpg')
img = img.resize((width,height),Image.NEAREST)
img.save('photo.jpg')
wb = openpyxl.Workbook()
ws = wb.worksheets[0]
img = openpyxl.drawing.image.Image('photo.jpg')
ws.add_image(img,'F10')
wb.save('out.xlsx')
print('ready')
这是可行的,如果您考虑以下因素:
This works, if you consider the following:
- 新工作簿已创建;
-
Photo.jpg
在原始文件中已更改;
- New workbook is created;
Photo.jpg
is changed in the original file;
这篇关于使用python在单元格Excel中填充图像的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文