Login   Register  
PHP Classes
elePHPant
Icontem

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

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author Author  
Picture of Karl Holz
Name: Karl Holz is available for providing paid consulting. Contact Karl Holz .
Classes: 11 packages by
Country: Canada Canada
Age: 33
All time rank: 86622 in Canada Canada
Week rank: 117 Up2 in Canada Canada Up
Innovation award
Innovation award
Nominee: 6x


  Detailed description   Download Download .zip .tar.gz   Install with Composer Install with Composer  
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.

  Classes of Karl Holz  >  PHP Convert Excel to JSON  >  Download Download .zip .tar.gz  >  Support forum Support forum (1)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: PHP Convert Excel to JSON
Base name: excel2json
Description: Convert data from Excel spreadsheet to JSON format
Version: 1.0.2
PHP version: 5.3
License: Custom (specified in a license file)
All time users: 576 users
All time rank: 4836
Week users: 2 users
Week rank: 872 Up
 
  Groups   Rate classes User ratings   Applications   Related pages   Files Files  

  Groups  
Group folder image XML XML parsing and generation View top rated classes
Group folder image PHP 5 Classes using PHP 5 specific features View top rated classes
Group folder image Files and Folders Listing, accessing and manipulating files and folders View top rated classes


  User ratings  
Not yet rated by the users

  Applications that use this package  
No pages of applications that use this class were specified.
Add link image 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 folder image Files  
File Role Description
Files folder imagexsl (3 files)
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 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 Doc. Updated Readme
Accessible without login Plain text file test.php Test value dump - test.php => dumps class values - show how to use excel data without JSON print out - $e->filter_cells() - $e->filter_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 StringLookup.xsl Data XSLT stylesheet, already embedded into class
  Accessible without login Plain text file workbooks.xsl Data XSLT stylesheet, already embedded into class

Install with Composer Install with Composer - Download Download all files: excel2json.tar.gz excel2json.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.