如果两者混用会有各自的报错信息: xlrd.biffh.XLRDError: Can't load sheets after releasing resources. AttributeError: 'Workbook' object has no attribute 'sheet_by_index' 打印type可以看出对象有区别: <class 'xlrd.sheet.Sheet'> <class 'xlwt.Worksheet.Worksheet'>
谨记以下用法即可:
import xlrd
from xlutils.copy import copy
pwb=xlrd.open_workbook('生活.xls')
#读取使用sheet_by_index()
pwbs=pwb.sheet_by_index(0)
print(type(pwbs))
cpwb=copy(pwb)
#get_sheet()用在新建中
cpwbs=cpwb.get_sheet(0)
print(type(cpwbs))