weixin_44838183 2019-03-27 22:45 采纳率: 0%
浏览 10400

新手小白,求教AttributeError: 'property' object has no attribute 'cell'解决方案

#!/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('文件已生成!')

  • 写回答

1条回答 默认 最新

  • dabocaiqq 2019-03-27 23:49
    关注
    评论

报告相同问题?

悬赏问题

  • ¥15 delta降尺度计算的一些细节,有偿
  • ¥15 Arduino红外遥控代码有问题
  • ¥15 数值计算离散正交多项式
  • ¥30 数值计算均差系数编程
  • ¥15 redis-full-check比较 两个集群的数据出错
  • ¥15 Matlab编程问题
  • ¥15 训练的多模态特征融合模型准确度很低怎么办
  • ¥15 kylin启动报错log4j类冲突
  • ¥15 超声波模块测距控制点灯,灯的闪烁很不稳定,经过调试发现测的距离偏大
  • ¥15 import arcpy出现importing _arcgisscripting 找不到相关程序