Read Error: Excel found unreadable content in file.xlsx. ... about php_xlsxwriter

[mk-j]

Can you narrow it down to which row is causing the issue, and put it in code? For instance:

include_once("xlsxwriter.class.php");
$my_string = "\xa35";//35 pounds (currency)
$my_string = mb_convert_encoding($my_string, 'UTF-8', 'windows-1252');
$writer = new XLSXWriter();
$writer->writeSheetRow('Sheet1', array($my_string) );
$writer->writeToFile('output.xlsx');

when I comment out mb_convert_encoding() above, and run this via command line php, i get this from stderr:
2014-11-14 20:58:44:Error, invalid UTF8 encoding detected.
But when I leave mb_convert_encoding() in there, the (above) spreadsheet seems to work for me.

What version of PHP?
What server is running PHP? (windows, linux, etc)
Is the .xlsx file a valid .zip file (can you rename it to .zip and unzip it, and the zip is not corrupted?)

[seattledeveloper]

I did copy the data over to my test server and went through it row by row. Here's the issue. I have a product model number "500E1205", which I have put in a column that is specified as a string. Unfortunately, either your code or Excel is seeing this as a number and I get a INF in the field where this should be located. Is there any way that your code can say this is truly a string? I noticed that your interpretation of cell contents uses a !is_string() call on line 233. Could this be viewed as a number by PHP when in reality it should be specified as a string when exported to Excel? So it turned out that it might not have had anything to do with character encoding.

BTW, I am using PHP 5.4.32 running on CentOS as an Apache module. And this .xlsx is a valid zip file. That's the first thing I checked before writing.

[mk-j]

Just committed a fix for that, let me know if it works for you.

[seattledeveloper]

I downloaded and tested on both my test environment and in production and both worked great. Thanks very much for your quick fix!

[seattledeveloper]

Thanks. And thanks again for your quick work on this!

[amitrana-dev]

Not sure if i am doing anything wrong, because got the same error with just writing following headers.

Array
(
    [Status] => string
    [Part Number] => string
    [Model Number] => string
    [Serial Number] => string
    [Manufacturer] => string
    [Condition] => string
    [Vendor] => string
    [Price] => string
    [Purchase Date] => string
    [Warranty Date] => string
    [Calibration Date] => string
)

Code i am using to generate is this:

// $theader output is above
$writer->writeSheetHeader('Sheet1', $theader );
header('Content-disposition: attachment; filename="'.$filename.'"');
header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
header('Content-Transfer-Encoding: binary');
$writer->writeToStdOut();

Edit: Ignore it, My problem was due to single space being printing before file output.

[mk-j]

This should be fixed properly in the latest version 0.30