Ok, I had little play with the test scripts, and in all honesty, it looks pretty damn good. It is however very expensive on memory and processor time. Also it has quite serious requirements (I don't quite see why the Zip extension is required, but there's probably a good reason for it).
Bellow script creates a very basic file. It has a peak memory usage of 7.75 MB and took 0.451s to complete.
$objPHPExcel = new PHPExcel();
// Set properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw");
$objPHPExcel->getProperties()->setLastModifiedBy("Maarten Balliauw");
$objPHPExcel->getProperties()->setTitle("Office 2007 XLSX Test Document");
$objPHPExcel->getProperties()->setSubject("Office 2007 XLSX Test Document");
$objPHPExcel->getProperties()->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.");
$objPHPExcel->getProperties()->setKeywords("office 2007 openxml php");
$objPHPExcel->getProperties()->setCategory("Test result file");
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Hello');
$objPHPExcel->getActiveSheet()->setCellValue('B2', 'world!');
$objPHPExcel->getActiveSheet()->setCellValue('C1', 'Hello');
$objPHPExcel->getActiveSheet()->setCellValue('D2', 'world!');
// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('Simple');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
// Save Excel 2007 file
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('C:\Documents and Settings\John\Bureaublad\1.6.2\test.xlsx');Writing an Excel5 file replacing the createWriter statement with:
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');Uses 8.25 MB and takes 0.4828.
File attached.
The memory usage stays about the same doing more complicated stuff, but processing time quickly skyrockets (and this is on a 'very fast' system).
Doing more complicated things apparently requires A LOT of coding. You have to apply stuff manually on every cell. Example:
$objPHPExcel->getActiveSheet()->getStyle('E11')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);Interface could be better. :/ Probably if I ever need to do something like this I would create an interface to apply styles on ranges.
I would post the code, but it's absolutely huge. It's included in the distribution anyway.
Creating this file took just over 8 seconds..
NOTE: I had rename the files from .xlsx to .txt to be able to upload them to the forums.
[attachment deleted by admin]
