PHP Script Codes > PHP ExcelExplorer Pro
This PHP class can import data from an Excel file without using COM, ODBC, etc. It will be useful in content management systems, for writting various converters (Excel to HTML, Excel to MySQL, etc.).
On-line demo and trial version available for download.
ExcelExplorer will work on any PHP5 platform. Supports Windows and Mac Excel files. No additional classes, modules are required. No configurations needed. Just include it in your own script and use it.
With this class you can read such data as used color, fonts, rich text, asian phonetics, etc. Shapes and images also supported.
What data can be imported: worksheets name, type (ordinal, chart or Visual Basic Module), visibility flag; rows and columns info; cells - type (integer and float numbers, percentage, text, formula, logical, error, date in Windows Excel and Mac Excel formats), empty, blank and merged.