I have a report which uses the WIN1253 (CP1253) character set. When I use export to excel I have the following problems : 1. When excel opens the file I get the message that the file format and the file extension do not agree and that probably the file is corrupt. When I open the file it shows the data except the Greek strings 2. All Greek strings (win1253) are replaced with FALSE.

Is there any news on this? It is something I need to finish my work and deliver it.

I managed to fix one of the problems (the Greek strings converted to FALSE) by changing line 47 ExcelExport.php from $text = Utility::format($row[$colKey], $colMetas[$colKey]); to $text = Utility::format(iconv ("CP1253", "UTF-8", $row[$colKey]), $colMetas[$colKey]); This works by changing the encoding of strings from CP1253 to UTF-8.

Is there a way to pass the encoding to ExcelExport.php with a parameter? Can you put this in your next version?

However I can't figure out why excel says that the format of the file is incorrect but after selecting to attempt to load the file it loads it successfully.

OK. I found also the second problem. The reason for the corrupt file message was that I was exporting to .xls instead of .xlsx. When I use xlsx it works fine.