PHP Classes

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

Recommend this page to a friend!
  Info   View files View files (26)   DownloadInstall with Composer Download .zip   Reputation   Support forum (4)   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 2,010 This week: 1All time: 1,956 This week: 61Up
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  
Name: Karl Holz <contact>
Classes: 14 packages by
Country: Canada Canada
Age: 43
All time rank: 44918 in Canada Canada
Week rank: 27 Up2 in Canada Canada Up
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  
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

  Files folder image Files  /  dist  
File Role Description
Files folder imagecss (4 files)
Files folder imagefonts (1 file)
Files folder imagejs (3 files)

  Files folder image Files  /  dist  /  css  
File Role Description
  Accessible without login Plain text file bootstrap-theme.css Data Auxiliary data
  Accessible without login Plain text file bootstrap-theme.min.css Data Auxiliary data
  Accessible without login Plain text file bootstrap.css Data Auxiliary data
  Accessible without login Plain text file bootstrap.min.css Data Auxiliary data

  Files folder image Files  /  dist  /  fonts  
File Role Description
  Accessible without login Plain text file glyphicons-halflings-regular.svg Data Auxiliary data

  Files folder image Files  /  dist  /  js  
File Role Description
  Accessible without login Plain text file bootstrap.js Data Auxiliary data
  Accessible without login Plain text file bootstrap.min.js Data Auxiliary data
  Accessible without login Plain text file jquery.min.js Data Auxiliary data

  Files folder image Files  /  xsl  
File Role Description
  Accessible without login Plain text file cellList.xsl Data XSLT stylesheet, already embedded into class
  Accessible without login Plain text file excel.xpr Data Auxiliary data
  Accessible without login Plain text file StringLookup.xsl Data XSLT stylesheet, already embedded into class
  Accessible without login Plain text file workbooks.xsl Data XSLT stylesheet, already embedded into class

 Version Control Unique User Downloads Download Rankings  
 100%
Total:2,010
This week:1
All time:1,956
This week:61Up