php lib Excel

<ul>
<li>PEAR's <a href="http://pear.php.net/package/Spreadsheet_Excel_Writer">PHP_Excel_Writer</a> (xls only)</li>
<li><a href="http://www.bettina-attack.de/jonny/view.php/projects/php_writeexcel/">php_writeexcel</a> from Bettina
Attack (xls only)</li>
<li><a href="http://paggard.com/projects/xls.generator/">XLS File Generator</a> commercial and xls only</li>
<li><a href="http://sourceforge.net/projects/excelwriterxml/">Excel Writer for PHP</a> from Sourceforge  (spreadsheetML only)</li>
<li>Ilia Alshanetsky's <a href="http://ilia.ws/archives/222-PHP-Excel-Extension.html">Excel extension</a> now on <a href="https://github.com/iliaal/php_excel">github</a> (xls and xlsx, and requires commercial <a href="http://www.libxl.com/">libXL</a> component)</li>
<li>PHP's <a href="http://www.php.net/manual/en/book.com.php">COM extension</a> (requires a COM enabled spreadsheet program such as MS Excel or OpenOffice Calc running on the server)</li>
<li>The Open Office alternative to COM (<a href="http://www.wstech2.net/index.php?do=0a,01,05">PUNO</a>) (requires Open Office installed on the server with Java support enabled)</li>
<li><a href="https://github.com/elidickinson/php-export-data/blob/master/php-export-data.class.php">PHP-Export-Data</a> by Eli Dickinson (Writes SpreadsheetML - the Excel 2003 XML format, and CSV)</li>
<li>Oliver Schwarz's <a href="https://github.com/oliverschwarz/php-excel">php-excel</a> (SpreadsheetML)</li>
<li>Oliver Schwarz's original version of <a href="http://code.google.com/p/php-excel/">php-excel</a> (SpreadsheetML)</li>
<li><a href="http://web.burza.hr/blog/php-class-for-exporting-data-in-multiple-worksheets-excel-xml/">excel_xml</a> (SpreadsheetML, despite its name)... link reported as broken</li>
<li>The tiny-but-strong (tbs) project includes the <a href="http://www.tinybutstrong.com/plugins/opentbs/tbs_plugin_opentbs.html">OpenTBS</a> tool for creating OfficeOpenXML documents (OpenDocument and OfficeOpenXML formats)</li>
<li><a href="http://faisalman.github.io/simple-excel-php/">SimpleExcel</a> Claims to read and write Microsoft Excel XML / CSV / TSV / HTML / JSON / etc formats</li>
<li><a href="http://demo.koolphp.net/Examples/KoolGrid/Exporting/Excel_Word_CSV_PDF/index.php">KoolGrid</a> xls spreadsheets only, but also doc and pdf</li>
<li><a href="https://github.com/mk-j/PHP_XLSXWriter">PHP_XLSXWriter</a> OfficeOpenXML</li>
<li><a href="https://github.com/SystemDevil/PHP_XLSXWriter_plus">PHP_XLSXWriter_plus</a> OfficeOpenXML, fork of PHP_XLSXWriter</li>
<li><a href="http://fossies.org/dox/php_writeexcel-0.3.0/class_8writeexcel__workbookbig_8inc_8php.html">php_writeexcel</a> xls only (looks like it's based on PEAR SEW)</li>
<li><a href="https://github.com/box/spout">spout</a> OfficeOpenXML (xlsx) and CSV</li>
<li><a href="https://github.com/Slamdunk/php-excel">Slamdunk/php-excel</a> (xls only) looks like an updated version of the old PEAR Spreadsheet Writer</li>
</ul>

<p>For Reading Excel</p>

<ul>
<li><a href="http://code.google.com/p/php-spreadsheetreader/">php-spreadsheetreader</a> reads a variety of formats (.xls, .ods and .csv)</li>
<li><a href="http://phpexcelreader.sourceforge.net/">PHP-ExcelReader</a> (xls only)</li>
<li><a href="http://code.google.com/p/php-excel-reader/">PHP_Excel_Reader</a> (xls only)</li>
<li><a href="http://code.google.com/p/php-excel-reader2/">PHP_Excel_Reader2</a> (xls only)</li>
<li><a href="http://paggard.com/projects/xls.reader/">XLS File Reader</a> Commercial and xls only</li>
<li><a href="http://www.phpclasses.org/package/6279-PHP-Parse-and-retrieve-data-from-Excel-XLS-files.html">SimpleXLSX</a> From the description it reads xlsx files , though the author constantly refers to xls</li>
<li><a href="http://www.eephp.com/">PHP Excel Explorer</a> Commercial and xls only</li>
<li>Ilia Alshanetsky's <a href="http://ilia.ws/archives/222-PHP-Excel-Extension.html">Excel extension</a> now on <a href="https://github.com/iliaal/php_excel">github</a> (xls and xlsx, and requires commercial <a href="http://www.libxl.com/">libXL</a> component)</li>
<li>PHP's <a href="http://www.php.net/manual/en/book.com.php">COM extension</a> (requires a COM enabled spreadsheet program such as MS Excel or OpenOffice Calc running on the server)</li>
<li>The Open Office alternative to COM (<a href="http://www.wstech2.net/index.php?do=0a,01,05">PUNO</a>) (requires Open Office installed on the server with Java support enabled)</li>
<li>Nuovo's <a href="https://github.com/nuovo/spreadsheet-reader">spreadsheet-reader</a> (csv, xls, xlsx, and ods)</li>
<li><a href="http://faisalman.github.io/simple-excel-php/">SimpleExcel</a> Claims to read and write Microsoft Excel XML / CSV / TSV / HTML / JSON / etc formats</li>
<li><a href="http://allitstuff.com/read-excel-file-in-php-with-example/">PHPExcleReader</a> Is just a ZIP with an old version of PHPExcel</li>
<li><a href="https://github.com/akeneo-labs/spreadsheet-parser">Akeneo Labs Spreadsheet Parser</a> OfficeOpenXML (.xlsx) and CSV files</li>
<li><a href="https://github.com/box/spout">spout</a> OfficeOpenXML (xlsx) and CSV</li>
<li><a href="https://github.com/xhook/php-spreadsheetreader">xhook's php-spreadsheetreader</a> Claims to do most formats</li>
</ul>

<p>A new C++ Excel extension for PHP, though you'll need to build it yourself, and the docs are pretty sparse when it comes to trying to find out what functionality (I can't even find out from the site what formats it supports, or whether it reads or writes or both.... I'm guessing both) it offers is <a href="https://github.com/SIMITGROUP/phpexcelib">phpexcellib</a> from SIMITGROUP.</p>

<p>All claim to be faster than <a href="http://www.phpexcel.net">PHPExcel</a> from <a href="http://phpexcel.codeplex.com">codeplex</a> or from <a href="http://www.phpexcel.net">github</a>, but (with the exception of COM, PUNO Ilia's wrapper around libXl and spout) they don't offer both reading and writing, or both xls and xlsx; may no longer be supported; and (while I haven't tested Ilia's extension) only COM and PUNO offers the same degree of control over the created workbook.</p>