#!/usr/bin/env python
-*- coding:utf-8 -*-
#sys.path.append('C:\Users\steven\AppData\Local\Programs\Python\Python36\Lib\site-packages\PIL')
求大神帮忙看看这段代码问题到底出在哪里?
环境:py3.6,库是Pillow5.4.1(64位),系统WIN7 64位。
错误提示:
cell = worksheet.cell(column = col, row = row1)
AttributeError: 'property' object has no attribute 'cell'
from openpyxl import Workbook
from openpyxl.utils import get_column_letter
from openpyxl.styles import PatternFill, Color
from PIL import Image
workbook = Workbook() # 激活 worksheet
worksheet = Workbook.active # 数据可以直接分配到单元格中
im = Image.open('D:\pycharmfile\excel_huatu\2.jpg')
im_width = im.size[0]
im_height = im.size[1]
pix = im.load()
n = 1
for row1 in range(1, im_height):
n = n + 1
for col in range(1, im_width):
** cell = worksheet.cell(column = col, row = row1)** #这是报错部分
pixprint = pix[col - 1, row1 - 1]
pixColor = "FF%02X%02X%02X" % (pixpoint[0], pixpoint[1], pixpoint[2])
fill = PatternFill(patternType='solid', fgColor=Color(rgb=pixColor))
cell.fill = fill
worksheet.row_dimensions[row1].height = 6
print('\r已完成:{:.2%}'.format(n/im_height), end = '')
print('\n正在生成文件,请稍后。。。')
for col in range(1, im_width):
worksheet.column_dimensions[get_column_letter(col)].width = 1
workbook.save('D:\pycharmfile\excel_huatu\20190326.xlsx')
print('文件已生成!')