|Classes of Karl Holz
|PHP Convert Excel to JSON
Excel2JSON is an Excel XML parser to JSON document
Won't work with excel (xls) docs exported with:
- Apache Open office (excel 2003 XML save as clashes) - Numbers - Libre Office (excel 2003 XML save as clashes)
I made test.xlsx with Oxygen XML, and edited it with LibreOffice. it is the test excel file provided with this class
* To see this class in action, view webpage.php and view it's code.
Note: if you get an error with the JSON output, set_excel with a second argument as seen bellow
other wise use
The makeconfig.php will generate an ini file so you can filter out cells and change their label, like A1 to Name and A2 the something like surname. Take a look at the example bellow or at the config.ini for more details.
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
Data test - print_sheet_data.php
Prints out a JSON document of excel worksheet cell data in detail
Cell test - print_sheet_cells.php
Prints out a JSON document of excel worksheet cell and their values
Rows test - print_sheet_rows.php
Prints out a JSON document of excel worksheet cell and values grouped into rows
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
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