如下,报错显示不可以在tmp_sh中使用append,但是我所看的教程当中这样是可行的……
from openpyxl import load_workbook,Workbook
wb = load_workbook('./raw_data/Chinese_score.xlsx')
sh = wb.active
title = []
for i,row in enumerate(sh.rows):
tmp_list = []
for cell in row:
tmp_list.append(cell.value)
if i<=1:
title.append(tmp_list)
else:
tmp_wb = Workbook
tmp_sh = tmp_wb.active
tmp_sh.append(title)
tmp_sh.append(tmp_list)
tmp_wb.save(f'./raw_data/Chinese_score工资条/{i-1}_{tmp_list[0]}.xlsx')
这边是报错信息:
Traceback (most recent call last):
File "c:\Users\Allen\Desktop\-\2021暑假\python编程\__\工资条练习.py", line 15, in <module>
tmp_sh.append(title)
AttributeError: 'property' object has no attribute 'append'
PS C:\Users\Allen\Desktop\-\2021暑假\python编程\__>
而在以下程序中,如下,这里的nsh是可以使用append的?
from openpyxl import load_workbook
wb1 = load_workbook('./raw_data/test_score_5.xlsx')
wb2 = load_workbook('./raw_data/test_score_11.xlsx')
sh1 = wb1.active
sh2 = wb2.active
from openpyxl import Workbook
nwb = Workbook()
nsh = nwb.active
for row in sh1.rows:
tmp_list = []
for cell in row:
tmp_list.append(cell.value)
nsh.append(tmp_list)
for row in sh2.rows:
tmp_list = []
for cell in row:
tmp_list.append(cell.value)
nsh.append(tmp_list)
nwb.save('./raw_data/test_score_together.xlsx')
这是为什么呢?该如何修改?
谢谢~