search

mk-j / PHP_XLSXWriter

Lightweight XLSX Excel Spreadsheet Writer in PHP
MIT License
1.84k stars 663 forks source link

Error when opening file generated with this library in a newer version of excel. #352

Open Modicrumb opened 10 months ago

Modicrumb commented 10 months ago

Excel spits this error out:

<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error306120_01.xml</logFileName><summary>Errors were detected in file 'C:\filepath\filename.xlsx'</summary><repairedRecords><repairedRecord>Repaired Records: Cell information from /xl/worksheets/sheet1.xml part</repairedRecord></repairedRecords></recoveryLog>

In version 2309. I have OSX and can open it in Numbers just fine. I am not sure if it works perfect in older versions of excel. What is the best way to troubleshoot this?

TonHaver commented 9 months ago

Hi,

I ran into the same problem. Tried a few things, problem was solved when I saved xlsxwriter.class.php in UTF8 encoding (instead of ANSI)

Hth, Ton