Python关于：DeprecationWarning: Call to deprecated function get_sheet_by_name (Use wb[sheetname])报错

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)