Comments not working when running on windows
Created originally on Bitbucket by tuxinger (Wilhelm Putz)
When runnning openpyxl on windows comments are not working. I tracked down the problem to openpyxl-1.8.3\openpyxl\reader\comments.py
method get_comments_file
The problem is that running on windows path.normpath
returns \ instead of / as directory separator, resulting in comments not read from source file. As a quickfix for me I did a comments_file=comments_file.replace('\\','/')
and it worked.