PHP Classes

PHP Convert Excel to JSON: Convert data from Excel spreadsheet to JSON format

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 2,013 All time: 1,954 This week: 57Up
Version License PHP version Categories
excel2json 1.0.7Custom (specified...5.3XML, PHP 5, Files and Folders
Description 

Author

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.

Picture of Karl Holz
  Performance   Level  
Innovation award
Innovation award
Nominee: 9x

 

Recommendations

Import excel file (xlsx format) into mysql database
I need to import excel data into database

  Files folder image Files (26)  
File Role Description
Files folder imagedist (3 directories)
Files folder imagexsl (4 files)
Accessible without login Plain text file Basic.test.php Example Example script
Accessible without login Plain text file config.ini Data Auxiliary data
Plain text file excelMap.class.php Class excel2JSON class
Accessible without login Plain text file LICENCE.txt Lic. Apache 2 licence
Accessible without login Plain text file makeconfig.php Example Example script
Accessible without login Plain text file 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
Accessible without login Plain text file 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
Accessible without login Plain text file 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
Accessible without login Plain text file print_sheet_cells.php Example cell test - print_sheet_cells.php Prints out a JSON document of excel worksheet cell and their values
Accessible without login Plain text file print_sheet_data.php Example data test - print_sheet_data.php Prints out a JSON document of excel worksheet cell data in detail
Accessible without login Plain text file 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
Accessible without login Plain text file README.md Doc. Documentation
Accessible without login Plain text file test.ini Data Auxiliary data
Accessible without login Plain text file webpage.php Example Example script

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:2,013
This week:0
All time:1,954
This week:57Up