/xl/styles.xml part with XML error. (Styles) Load error.

%3CLINGO-SUB%20id%3D%22lingo-sub-2321105%22%20slang%3D%22en-US%22%3E%2Fxl%2Fstyles.xml%20part%20with%20XML%20error.%20(Styles)%20Load%20error.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2321105%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20getting%20this%20very%20annoying%20bug%20when%20using%20python%20panda%20ExcelWriter%20(engine%3D'xlsxwriter').%20I%20am%20colouring%20in%20specific%20cells%20of%20the%20worksheet%2C%20but%20when%20I%20try%20and%20open%20the%20file%20with%20excel%20I%20get%20this%20error%20message%3A%26nbsp%3B%20%2Fxl%2Fstyles.xml%20part%20with%20XML%20error.%20(Styles)%20Load%20error.%3C%2FP%3E%3CP%3Eand%20then%20I%20can%20only%20recover%20the%20document%20without%20the%20formatting.%20I%20have%20imported%20xlsxwriter%20and%20have%20no%20error%20messages%20from%20python.%20Thanks%20in%20advance%20for%20any%20tips!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2321105%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2322310%22%20slang%3D%22en-US%22%3ERe%3A%20%2Fxl%2Fstyles.xml%20part%20with%20XML%20error.%20(Styles)%20Load%20error.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2322310%22%20slang%3D%22en-US%22%3ECan%20you%20have%20it%20generate%20an%20example%20workbook%20and%20upload%20it%20here%3F%20Please%20indicate%20which%20cells%20you%20tried%20to%20color.%3C%2FLINGO-BODY%3E
Visitor

Hello everyone

 

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!

1 Reply
Can you have it generate an example workbook and upload it here? Please indicate which cells you tried to color.