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,012 All time: 1,955 This week: 43Up
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: 44
All time rank: 44918 in Canada Canada
Week rank: 41 Up1 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 (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

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

  Files folder image Files (26)  /  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 (26)  /  dist  /  fonts  
File Role Description
  Accessible without login Plain text file glyphicons-halflings-regular.svg Data Auxiliary data

  Files folder image Files (26)  /  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 (26)  /  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

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,012
This week:0
All time:1,955
This week:43Up