Pear Spreadsheet_Excel_Writer vs. PHP 5.3
Pear Spreadsheet_Excel_Writer created on PHP 4.
Trials to solve problem:
https://github.com/pear/Spreadsheet_Excel_Writer
other software:
http://www.fusonic.net/en/blog/2012/03/08/simplified-php-spreadsheet-excel-export/
deprecated error report & solution:
http://pear.php.net/bugs/bug.php?id=16678&edit=3
error when deal with a large amount of data
http://stackoverflow.com/questions/2674489/spreadsheet-excel-writer-data-output-is-damaged
The solution is change in Root.php line 623 :
fwrite($FILE, pack("V", 1));
to
fwrite($FILE, pack("V", $num_sb_blocks));
the file is pear/OLE/PPS/Root.php in package OLE 1.0.0RC2 (beta)