I am getting this very annoying bug when using python panda ExcelWriter (engine='xlsxwriter'). I am colouring in specific cells of the worksheet, but when I try and open the file with excel I get this error message: /xl/styles.xml part with XML error. (Styles) Load error.
and then I can only recover the document without the formatting. I have imported xlsxwriter and have no error messages from python. Thanks in advance for any tips!