option to suppress "extension is not supported" warning messages
Created originally on Bitbucket by Greg Pflaum
It would be nice to have a way to suppress the “extension is not supported and will be removed” warning. I’m reading a workbook that has an unsupported extension, and I don’t want the warning to appear in my program’s output.
/Users/gpflaum/miniconda2/envs/py37/lib/python3.7/site-packages/openpyxl/worksheet/_reader.py:300: UserWarning: Data Validation extension is not supported and will be removed
warn(msg)
Perhaps something like this:
# Ignore these extensions
ignore_me = ['Data Validation', 'Protected Range']
wb = load_workbook('example.xlsx', ignore_extensions=ignore_me)
# Ignore all extensions
wb = load_workbook('example.xlsx', ignore_extensions=True)