Alternative for PHP_excel

Question

Hi, Is there any alternative for PHP_ecxel. Which can "Export ro Xlsx/xls" file in a customized format.

Answer 1

• PEAr's PHP_Excel_Writer (xls only)
• php_writeexcel from Bettina Attack (xls only)
• Excel Writer for PHP from Sourceforge (xlsx only)
• Ilia Alshanetsky's Excel extension (xls only, and requires commercial component)
• PHP's .COM extension (requires a COM enabled spreadsheet program such as MS Excel or OpenOffice Calc running on the server)

All are faster than PHPExcel, but (with the exception of .COM) they don't offer both reading and writing, or both xls anxd xlsx; may no longer be supported; and (while I haven't tested Ilia's extension) only .COM offers the same degree of control over the created workbook.

I apologise that I haven't responded to your last posting in the row autofit question where you gave me a load of your code that needed changing, but a) I didn't know which rows/fields you wanted to wrap, and b) I don't actually write people's code for them when I've already answered the question (with example code) so that they can do so themselves.

Answer 2

I wrote a very simple class for exporting to "Excel XML" aka SpreadsheetML. It's not quite as convenient for the end user as XSLX (depending on file extension and Excel version, they may get a warning message), but it's a lot easier to work with than XLS or XLSX.

http://github.com/elidickinson/php-export-data