Python 2.7 Openpyxl 用户警告

Question

为什么我每次运行代码时都会收到此警告消息？ (以下)。有可能摆脱它吗？如果是这样，我该怎么做？

我的代码:

from openpyxl import load_workbook
from openpyxl import Workbook

wb = load_workbook('NFL.xlsx', data_only = True)
ws = wb.active
sh = wb["Sheet1"]


ptsDiff = (sh['J127'].value)
print ptsDiff

代码有效，但我收到此警告消息:

Warning (from warnings module):
  File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/openpyxl/reader/worksheet.py", line 320
warn(msg)
UserWarning: Unknown extension is not supported and will be removed

Answer 1

当 openpyxl 无法理解/读取扩展 (source) 时，会发生此错误。这是 list of built-in extensions openpyxl currently knows that is doesn't support :

• 条件格式
• 数据验证
• 迷你图组
• 切片器列表
• 保护区
• 忽略错误
• 网络扩展
• 切片器列表
• 时间表引用

另见 Worksheet extension list specification .