PHP Convert Excel to JSON
| Recommend this page to a friend! |  Stumble It! |
 Bookmark in del.icio.us |
| Author | ||
 |
|
Innovation award Nominee: 6x | |||||||||||||||||||
This class can convert data from Excel spreadsheet to JSON format.
It uses XSL stylesheets to parse Excel XML formats (xlsx and xlsm) and extract data from the spreadsheet cells.
The class can convert the extracted spreadsheet data into JSON format.
The converted JSON data is served for download.
It uses XSL stylesheets to parse Excel XML formats (xlsx and xlsm) and extract data from the spreadsheet cells.
The class can convert the extracted spreadsheet data into JSON format.
The converted JSON data is served for download.
| Classes of Karl Holz | > | PHP Convert Excel to JSON | > | Download .zip .tar.gz | > |  Support forum |
> |  Blog |
> |   Latest changes |
||
|
|||||||||||||||||||||||
| Groups | Freshmeat project |  User ratings |
||||
| Applications | Related links |  Files |
||||
| Groups | ||
 |
XML | XML parsing and generation | View top rated classes |
|
PHP 5 | Classes using PHP 5 specific features | View top rated classes |
|
Files and Folders | Listing, accessing and manipulating files and folders | View top rated classes |
| Freshmeat project | ||
| Project record: | excel2json |
|---|---|
| Popularity score: | 34.64 |
| Vitality score: | 8.5 |
| User ratings | ||
| Not yet rated by the users |
| Applications that use this class | ||
No application links were specified for this class.
If you know an application of this package, send a message to the author to add a link here.| Related links | ||
| Link | Description |
|---|---|
| Homepage | download excel file used to test this class |
| Documentation | PHP Doc |
| Files |
||
| File | Role | Description | ||
|---|---|---|---|---|
| xsl (3 files) |
||||
| excelMap.class.php |
Class | excel2JSON class | ||
 LICENCE.txt |
Lic. | Apache 2 licence | ||
| print_filter_cells.php |
Example | cell filter test - print_filter_cells.php Prints out a JSON document of excel worksheet cell and their values, only cells added to cell list will be displayed | ||
| print_filter_data.php |
Example | data filter test - print_filter_data.php Prints out a JSON document of excel worksheet cell data in detail, only cells added to cell list will be displayed | ||
| print_sheets.php |
Example | sheets test - print_sheets.php => on by default if worksheet not found or set. Prints out a JSON document of a list of excel workbook sheets | ||
| print_sheet_cells.php |
Example | cell test - print_sheet_cells.php Prints out a JSON document of excel worksheet cell and their values | ||
| print_sheet_data.php |
Example | data test - print_sheet_data.php Prints out a JSON document of excel worksheet cell data in detail | ||
| print_sheet_rows.php |
Example | rows test - print_sheet_rows.php Prints out a JSON document of excel worksheet cell and values grouped into rows | ||
| README |
Doc. | Updated Readme | ||
| test.php |
Test | value dump - test.php => dumps class values - show how to use excel data without JSON print out - $e->filter_cells() - $e->filter_data() | ||
| Files | / | xsl |
||
| File | Role | Description |
|---|---|---|
| cellList.xsl |
Data | XSLT stylesheet, already embedded into class |
| StringLookup.xsl |
Data | XSLT stylesheet, already embedded into class |
| workbooks.xsl |
Data | XSLT stylesheet, already embedded into class |
| Download all files: excel2json.tar.gz excel2json.zip |
For more information send a message to info at phpclasses dot org.
Copyright (c) Icontem 1999-2013