Error Opening Excel (XLSX) Files From Pandas Xlsxwriter

Upon opening an XLSX file in MS Excel, an error dialog is presented: 'We found a problem with some content in filename.xlsx ...' Clicking 'Yes' to attempt recovery yields the foll

Solution 1:

As suggested by @jmcnamara, the author of XlsxWriter, the issue was identified to be an unintended formula. By turning off the default conversion of strings to formulas with the strings_to_formulas option, the issue was resolved.

pd.ExcelWriter('filename.xlsx', engine='xlsxwriter', options={'strings_to_formulas': False})