PhpRiot
News Archive
PhpRiot Newsletter
Your Email Address:

More information

Import and export data using PHPExcel

Note: This article was originally published at Planet PHP on 15 July 2010.
Planet PHP
A few weeks ago I had to read and write Excel files of the format BIFF8 (Excel 97), because the customer did not accept the workaround of exporting data to CSV. PEAR's Spreadsheet_Excel_Writer combined with the project Spreadsheet_Excel_Reader on SourceForge was a good helper in the past - but only for BIFF5. BIFF8 support in spreadsheet excel writer has been a problem for a long time, and according to the authors, is still somewhat kludgy in the current version. So I needed an alternative.
After a short research I stumbled upon PHPExcel which supports reading and writing of many formats in one API. It is released under the GNU Lesser General Public License which gives you the freedom to use it in commercial applications. Output and input formats are not limited to Excel files. This article gives you a short overview about what you can do with it and demonstrates the basic usage.
Continue reading "Import and export data using PHPExcel"