2019-09-02 Python的openpyxl遇到Depr

在调用openpyxl时，出现Warning：

DeprecationWarning: Call to deprecated function get_sheet_by_name (Use wb[sheetname])

代码行为：

sheet = wc.get_sheet_by_name('Sheet')

解决方案：代码行改为

sheet = wc["Sheet"]

参考

• python - DeprecationWarning: Call to deprecated function get_sheet_by_name (Use wb[sheetname]) - Stack Overflow
• python - What does this mean? DeprecationWarning: Call to deprecated function get_sheet_by_name (Use wb[sheetname]) - Stack Overflow