大家看看这段代码为什么会报错

# encoding:utf-8
import xlrd,xlwt
def stary(names,hight,cole):
    staryer=xlwt.XFStyle
    fone=xlwt.Font
    fone.name=names
    fone.height=hight
    fone.bold=True
    fone.underline=True
    fone.colour_index=cole
    fone.outline=True
    staryer.font=fone
a=input('请选择字体：')
b=input('字体大小：')
c=input('字体颜色：')
book=xlwt.Workbook()
new_sheet=book.add_sheet('新建工作表')
new_sheet2=book.add_sheet('新建工作表2')
book.save('d:\新建工作部.xsl')
wookbook=xlrd.open_workbook('d:\新建工作部.xsl')
sheet=wookbook.sheet_by_index(0)
sheet2=wookbook.sheet_by_index(1)
sheet.write(0,0,'实验',stary(a,b,c))
book.save('d:\新建工作部.xsl')

这是报错信息

请选择字体：'Time New Roman'

字体大小：500

字体颜色：3

Traceback (most recent call last):

File "D:/S14/python模块/xlrd模块.py", line 23, in <module>

sheet.write(0,0,'实验',stary(a,b,c))

AttributeError: 'Sheet' object has no attribute 'write'

慕容1479236

2019-06-15

源自：初识Python 3-1

关注问题我要回答

3253

操作

收起

3 回答

黑鱼26
2019-07-09

sheet对象没有write属性

0 回复有任何疑惑可以回复我~

收起回答

慕容1479236 提问者
2019-06-16

# encoding:utf-8
import xlrd,xlwt
def stary(names,hight,cole):
    staryer=xlwt.XFStyle
    nfone=xlwt.Font
    nfone.name=names
    nfone.height=hight
    nfone.bold=True
    nfone.underline=True
    nfone.colour_index=cole
    nfone.outline=True
    staryer.font=nfone
a=input('请选择字体：')
b=input('字体大小：')
c=input('字体颜色：')
book=xlwt.Workbook()
new_sheet=book.add_sheet('新建工作表')
new_sheet2=book.add_sheet('新建工作表2')
book.save('d:\新建工作部.xsl')
wookbook=xlrd.open_workbook('d:\新建工作部.xsl')
sheet=wookbook.sheet_by_index(0)
sheet2=wookbook.sheet_by_index(1)
new_sheet.write(0,0,'实验',stary(a,b,c))
book.save('d:\新建工作部.xsl')

你看看这样我依然出错

C:\Users\25063\Anaconda3\python.exe D:/S14/python模块/xlrd模块.py

请选择字体：Malgun Gothic

字体大小：400

字体颜色：3

Traceback (most recent call last):

File "D:/S14/python模块/xlrd模块.py", line 23, in <module>

new_sheet.write(0,0,'实验',stary(a,b,c))

File "C:\Users\25063\Anaconda3\lib\site-packages\xlwt\Worksheet.py", line 1088, in write

self.row(r).write(c, label, style)

File "C:\Users\25063\Anaconda3\lib\site-packages\xlwt\Row.py", line 229, in write

self.__adjust_height(style)