What is ExcelExplorer?
ExcelExplorer is a set of PHP5 classes that can read data from a MS Excel file without using COM, ODBC, etc.
It can import data from binary Excel file (XLS) using only standard PHP functions.
This means that Excel Explorer will work on any PHP-powered platform (Windows, Unix or other).
No additional classes, modules, libraries or databases are required. No configurations needed. Just include it in your own script and use it!
ExcelExplorer is not a stand-alone application. Instead of this it provides easy-to-use, multifunctional programming interface for the PHP programmers.
Using build-in caching, controlling what data to read, new features presented in PHP5 and many other techniques it's provides impressive speed, stability and optimal memory usage.
Using ExcelExplorer you can retrieve data even from merged cells, formulas, date cells; get information about rows and columns (hidden, grouped, height, width), sheets (hidden, chart, Visual Basic Module), get information about cell styles (color, font, format), etc.
You can read data from Excel files created on Windows or Mac platforms.
If cell contains date information it will be automatically converted using 1900 (if file stored using Windows Excel) or 1904 (if file stored using Macintosh Excel) date systems.
At the present time ExcelExplorer is the most complete solution in the internet. Well documented API makes development with ExcelExplorer
faster and easier. Source code contains PHPDOC comments that using in several development enviroments, such as Zend Studio (Zend Development Environment).
| Main Features |
| Supported Excel versions |
Excel 5.0 / Excel 7.0 (Excel 95) / Excel 8.0 (Excel 97) / Excel 9.0 (Excel 2000) / Excel 10.0 (Excel XP) / Excel 11.0 (Excel 2003) and above |
| OS |
any OS that supports PHP (Windows - all versions, Linux, FreeBSD, Mac OS X, Novell NetWare, OS/2, RISC OS, SGI IRIX 6.5.x, etc. - see supported platforms on www.php.net) |
| Requirements |
PHP 5.0.1 and above |
| Distribution |
ZIP-file, containing class source code and samples (inclusive sample that you can see at on-line demo section). Demo version available for download.
|
| Upgrades |
FREE upgrades to the newest version for 1 year after purchasing |
| Types of Data Supported |
| Sheets |
Title, type (ordinary, chart, Visual Basic Module), visibility |
| Columns and Rows |
Width and height, grouping level, visibility |
| Cell Data Types |
Integer, float, text (string), formula, hyperlink, logical (boolean), error (error code), empty, blank |
| Cell Data Formats |
Floating-point precision, percentage, date and others |
| Cell Styles |
Rich-text strings (multiple font styles in one cell), asian phonetics, merged cells, font, string format, foreground and background colors, alignment, borders |
| Images and Shapes |
Images in different formats, shapes that controls where and how image must be shown. |
| Summary information |
MS Office files contain summary information (creation date, author, OS used, title and other). |
| Engine Features |
| Build-in caching |
| Multiple extraction modes for memory-limited systems (tested on files about 800 megabytes) |
| Controlling data extraction process by setting appropriate option flags |
| Object-oriented API |
Typical usage scheme
Please note that this is just example to show you advantages of using ExcelExplorer. Range of application is not limited by this particular task.
| Without ExcelExplorer |
With ExcelExplorer |
 |
 |
- You (or your customers) must opens file in MS Excel and save each sheet using CSV format before upload.
- You have to upload each CSV file individually as many times as many sheets need to be uploaded
- Using this method you will be unable to read any information about cells format, font, color, merged cells, rows and columns sizes, and many others.
|
- You can make process of uploading and using data from Excel files fully automated.
- Saves a lot of time (epecially for multi-worksheets files).
- You can read information about cells formats, fonts, colors, merged cells, rows and columns sizes, and many others.
|
Benefits of using ExcelExplorer
- Reads multi-worksheets files at-once;
- Can read data from Excel files created in Windows and MacOS enviroments;
- OS-independent - it works on any platform with installed PHP (Windows, Linux, FreeBSD, Mac OS X, Novell NetWare, OS/2, RISC OS, SGI IRIX 6.5.x, etc. - see supported platforms on www.php.net);
- No configurations needed;
- No other libraries or classes are required;
- Only basic PHP programming skills are required to use this package;
- Free updates to the newest version will be provided for 1 year after purchasing;
- New versions intensively tested before released;
- New features added and new versions released on a regular basis.
|
