PHP Convert Excel to JSON: Convert data from Excel spreadsheet to JSON format
| Recommend this page to a friend! |
 Author |
 |
|
Innovation award Nominee: 9x | |||||||||||||||||||
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 (4) |
> |  Blog |
> |   Latest changes |
|
|
|
||||||||||||||||||||||
| Groups |  User ratings |
Applications | Related pages |  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 |
| Recommendations |
Import excel file (xlsx format) into mysql database
I need to import excel data into database
| Applications that use this package |
No pages of applications that use this class were specified.
If you know an application of this package, send a message to the author to add a link here.
| Related pages |
| Homepage download excel file used to test this class |
| Documentation PHP Doc |
| Files |
| File | Role | Description | ||
|---|---|---|---|---|
| dist (3 directories) |
||||
| xsl (4 files) |
||||
 Basic.test.php |
Example | Example script | ||
| config.ini |
Data | Auxiliary data | ||
| excelMap.class.php |
Class | excel2JSON class | ||
| LICENCE.txt |
Lic. | Apache 2 licence | ||
| makeconfig.php |
Example | Example script | ||
| 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.md |
Doc. | Documentation | ||
| test.ini |
Data | Auxiliary data | ||
| webpage.php |
Example | Example script | ||
| Files |
/ | dist | / | css |
| File | Role | Description |
|---|---|---|
| bootstrap-theme.css |
Data | Auxiliary data |
| bootstrap-theme.min.css |
Data | Auxiliary data |
| bootstrap.css |
Data | Auxiliary data |
| bootstrap.min.css |
Data | Auxiliary data |
| Files |
/ | dist | / | js |
| File | Role | Description |
|---|---|---|
| bootstrap.js |
Data | Auxiliary data |
| bootstrap.min.js |
Data | Auxiliary data |
| jquery.min.js |
Data | Auxiliary data |
| Files |
/ | xsl |
| File | Role | Description |
|---|---|---|
| cellList.xsl |
Data | XSLT stylesheet, already embedded into class |
| excel.xpr |
Data | Auxiliary data |
| StringLookup.xsl |
Data | XSLT stylesheet, already embedded into class |
| workbooks.xsl |
Data | XSLT stylesheet, already embedded into class |
 Install with Composer - Download all files: excel2json.tar.gz excel2json.zipNOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.
|
