openpyxl compatibility warning doesn't catch no openpyxl installed

[patricktokeeffe]

Just installed 0.14.0 (on Windows 7) and received this warning:

Installed openpyxl is not supported at this time. Use >=1.6.1 and <2.0.0.

I did not have any version of openpyxl installed though. Perhaps the change made to pandas/io/excel.py in #7214 should have been more like:

-register_writer(_OpenpyxlWriter)
+
+openpyxl_check = openpyxl_compat.is_compat()
+if openpyxl_check is None:
+    warn('Could not import openpyxl -- not using.')
+elif openpyxl_check:
+    register_writer(_OpenpyxlWriter)
+else:
+    warn('Installed openpyxl is not supported at this time. Use >={} and <{}.'
+            .format(openpyxl_compat.start_ver, openpyxl_compat.stop_ver))

---

As a side note, I received the same warning after installing openpyxl 1.9.0 but it was because I didn't have lxml (<-- I may have misspelled this module name).

[jreback]

see here: #7284

ready fixed in master/0.14.1

thanks for. the report

[dhomeier]

=1.6.1 and <2.0.0 does not really work, does it?
At least _OpenpyxlWriter._convert_to_style has its problems because
openpyxl.style changed its name to openpyxl.styles by 1.8, and in 1.9.0 on top of this the
Style.borders method has morphed to Style.border and its __setattr__ also seems to work differently.
Bottom line is, with
from openpyxl.styles import Style
the excel-related tests seem to succeed with 1.8.6, yet not with 1.9.0.