I understand that PHPExcel has a lot of features for spreadsheet generation and manipulation. However, I have an instance where I need to create lots of sheets and files without any bells and whistles, in OOXML format. Unfortunately, for the bare bones,
PHPExcel isn't doing so swift.
Is there any alternative writer that does nothing special: just writes values to cells, and exports in OO XML?
To give you an idea my problems with PHPExcel; I ran tests on a single workbook with one worksheet consisting of 6.2k rows, 18 columns, no formulas, and column 18 formatted with $#,##0.00.
Using Spreadsheet_Excel_Writer: ~.5 seconds to write the worksheet. ~.3 to export (->close())
Using PHPExcel: ~10 seconds to write the worksheet. ~30 seconds to export (->save('php://output')) (using Excel5 and Excel2007 writer: no difference in general speed)
Those numbers are very consistent throughout all my tests.
In PHPExcel, I'm using setCellValueExplicit() on every cell -- it's the fastest method I have found. fromArray() actually showed everything down considerably (~30 seconds). I don't use any formulas; it's all direct value writing as number or as string.
How is it that Spreadsheet_Excel_Writer can be, by orders of magnitude, so much faster? Unfortunately, SEW doesn't support OOXML.