IT Technical Support for Developers
PHP Excel
PHPExcel - OpenXML - Read, Write Excel in PHP
PHPExcel - OpenXML
PHP - Spreadsheet engine - Parse and retrieve information from XLS files
Project providing a set of classes for the PHP programming language, which allow you to write to and read from different spreadsheet file formats, like Excel (BIFF) .xls, Excel 2007 (OfficeOpenXML) .xlsx, CSV, Libre/OpenOffice Calc .ods, Gnumeric, PDF, HTML, ... This project is built around Microsoft's OpenXML standard and PHP.
Checkout the Features this class set provides, such as setting spreadsheet meta data (author, title, description, ...), multiple worksheets, different fonts and font styles, cell borders, fills, gradients, adding images to your spreadsheet, calculating formulas, converting between file types and much, much more!
Download PHPExcel 1.8.0
All code is now maintained on github
Last release here on codeplex: PHPExcel 1.8.0 https://phpexcel.codeplex.com/releases/view/119187
Requirements
PHP version 5.2.0 or higherPHP extension php_zip enabled *)
PHP extension php_xml enabled
PHP extension php_gd2 enabled (if not compiled in)
All part of the PHP package (zip) on http://www.php.net/downloads.php, should be enabled in php.ini
*) php_zip is only needed by PHPExcel_Reader_Excel2007, PHPExcel_Writer_Excel2007, PHPExcel_Reader_OOCalc. In other words, if you need PHPExcel to handle .xlsx or .ods files you will need the zip extension, but otherwise not.
PHP Excel, Reading an Excel File in Php
PHP Excel Reader - Google Code
PHP Excel Reader - Parse and retrieve information from XLS files
This PHP library expands on the great work done in the PHP Excel Reader project on SourceForge.
It reads the binary format of XLS files directly and can return values and formats from any cell.
Example
Microsoft Excel Screenshot
PHP Output
By simply using this php command:
dump(true,true); ?>
The output looks like this (with some CSS):
Latest Post
/Windows
/Windows
/Windows
/Tally Integration Capabilities
/Windows