我试图用python读取excel文件的单元格,更改其值并保存它。如果代码中没有from xlutils.copy import copy
行,它将识别workbook.sheeets()
,否则它会显示
AttributeError: 'Workbook' object has no attribute 'sheets'
from xlutils.copy import copy
import xlrd
st = xlwt.easyxf('pattern: pattern solid;')
rb = xlrd.open_workbook('00-17.xlsx')
workbook = copy(rb)
for sheet in workbook.sheets():
for row in range(sheet.nrows):
current_value = sheet.cell(row,3).value
if(current_value == '1' ) :
st.pattern.pattern_fore_colour = 5
for column in [0,2,3]:
value = sheet.cell(row, column).value
print value
sheet.write(row, column, value,st)
workbook.save('1.xlsx')
我相信您可能必须先使用load_workbook()方法。查看链接Print Excel workbook using python它可能会有帮助。
你能试着用
workbook = xlrd.open_workbook('00-17.xlsx')
来做,并删除workbook = copy(rb)
行吗?相关问题 更多 >
编程相关推荐