关于 OPENPYXL 写入表格的问题
(第一次发帖,有不规范处请原谅)请教一下
我有如下代码(windows,py3.8),目的是新建一个excel中并写入数据,最后保存,中间的输出和输出到txt文件是对输入内容的调试,都正常,但是加入了对excel表格读写后运行后却提示“AttributeError: 'property' object has no attribute 'cell'”
,到处教程学习,都没有找到答案,请各位指导一下 |
import re
from openpyxl import Workbook
ff = open('C:\\Users\\19062\\Desktop\\3.txt')
ee = open('C:\\Users\\19062\\Desktop\\2.txt', 'w+')
wb = Workbook
ws = wb.active
ws_hang = 1
ws_lie_name = 1
ws_lie_gps = 2
ff.seek(0)
fftext = ff.readlines()
z = len(fftext)
for i in range(0, z):
if 'name' in str(fftext[i]):
out = re.search(r'<name>(.*)</name>(.*)', fftext[i])
print('道路名称:', out.group(1))
ee.write(out.group(1))
ws.cell(row=ws_hang, column=ws_lie_name).value = out.group(1)
ws_hang = ws_hang + 1
elif 'coordinates' in fftext[i]:
out = re.search(r'<coordinates>(.*)</coordinates>(.*)', fftext[i])
print('坐标:', out.group(1))
ee.write(out.group(1))
ws.cell(row=ws_hang, column=ws_lie_gps).value = out.group(1)
ff.close()
ee.close()
wb.save('C:\\Users\\19062\\Desktop\\2.xlsx')
已经发现问题了,主要是wb = Workbook后面查一个(),修改成wb = Workbook()就正确了,谢谢
推荐文章: