DeprecationWarning: Call to deprecated function get_sheet_by_name (Use wb[sheetname])报错
源码
import openpyxl
wb = openpyxl.load_workbook(r"C:\Users\wangfei2\Desktop\xlsx文件\RewardResource.xlsx")
sheet = wb.get_sheet_by_name('Sheet1')
print(sheet)
修改后(报错里面提示用:wb[sheetname]的格式)
import openpyxl
wb = openpyxl.load_workbook(r"C:\Users\wangfei2\Desktop\xlsx文件\RewardResource.xlsx")
sheet = wb['Sheet1']
print(sheet)