ENH: Upgrade Excel I/O module to use OpenPyXL 2 · Issue #7177 · pandas-dev/pandas (original) (raw)

OpenPyXL v2.0 was released on May 13th, breaking backwards compatibility in some parts of its API, including those upon which pandas depends. Notably, v2 changes the style API and makes Style objects immutable. This incompatibility is evident at 0.14.0-rc1 in pandas.io.excel._OpenpyxlWriter._convert_to_style and the associated test case, pandas.io.tests.test_excel.OpenyxlTests.test_to_excel_styleconverter.

In addition to teaching pandas how to use the new API, the project may wish to retain support for the OpenPyXL v1 API, necessitating the design and development of a compatibility shim.