2015. március 12., csütörtök

PHPExcel

A pure PHP library for reading and writing spreadsheet file.  https://github.com/PHPOffice/PHPExcel


Home page:  http://phpexcel.codeplex.com/wikipage?title=Examples


Use 01simple-download-xls.php if you want output to a client’s web browser (Excel5)


If you gotn this error: “exception ‘PHPExcel_Calculation_Exception’ with message”.

Add this
$objWriter->setPreCalculateFormulas(false);

row before save:


$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

//$objWriter->setPreCalculateFormulas(false);

$objWriter->save('php://output');


info from here: https://phpexcel.codeplex.com/discussions/237881



PHPExcel