| Recommend this page to a friend! | 
|  Download | 
| Info |  Files |  Install with Composer |  Download | Reputation | Support forum | Blog | Links | 
| Ratings | Unique User Downloads | Download Rankings | ||||
| Not enough user ratings | Total: 2,013 | All time:  1,954 This week: 57  | ||||
| Version | License | PHP version | Categories | |||
| excel2json 1.0.7 | Custom (specified... | 5.3 | XML, PHP 5, Files and Folders | 
| Description | Author | |
| This class can convert data from Excel spreadsheet to JSON format. | 
Import excel file (xlsx format) into mysql database
I need to import excel data into database
|  Files (26) | 
| File | Role | Description | ||
|---|---|---|---|---|
|  dist (3 directories) | ||||
|  xsl (4 files) | ||||
|    Basic.test.php | Example | Example script | ||
|    config.ini | Data | Auxiliary data | ||
|  excelMap.class.php | Class | excel2JSON class | ||
|    LICENCE.txt | Lic. | Apache 2 licence | ||
|    makeconfig.php | Example | Example script | ||
|    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 | ||
|    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 | ||
|    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 | ||
|    print_sheet_cells.php | Example | cell test - print_sheet_cells.php Prints out a JSON document of excel worksheet cell and their values | ||
|    print_sheet_data.php | Example | data test - print_sheet_data.php Prints out a JSON document of excel worksheet cell data in detail | ||
|    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 | ||
|    README.md | Doc. | Documentation | ||
|    test.ini | Data | Auxiliary data | ||
|    webpage.php | Example | Example script | ||
|  Files (26) | / | dist | / | css | 
| File | Role | Description | 
|---|---|---|
|    bootstrap-theme.css | Data | Auxiliary data | 
|    bootstrap-theme.min.css | Data | Auxiliary data | 
|    bootstrap.css | Data | Auxiliary data | 
|    bootstrap.min.css | Data | Auxiliary data | 
|  Files (26) | / | dist | / | fonts | 
| File | Role | Description | 
|---|---|---|
|    glyphicons-halflings-regular.svg | Data | Auxiliary data | 
|  Files (26) | / | dist | / | js | 
| File | Role | Description | 
|---|---|---|
|    bootstrap.js | Data | Auxiliary data | 
|    bootstrap.min.js | Data | Auxiliary data | 
|    jquery.min.js | Data | Auxiliary data | 
|  Files (26) | / | xsl | 
| File | Role | Description | 
|---|---|---|
|    cellList.xsl | Data | XSLT stylesheet, already embedded into class | 
|    excel.xpr | Data | Auxiliary data | 
|    StringLookup.xsl | Data | XSLT stylesheet, already embedded into class | 
|    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 | 
| Version Control | Unique User Downloads | Download Rankings | |||||||||||||||
| 100% | 
 | 
 | 
| Applications that use this package | 
 If you know an application of this package, send a message to the author to add a link here.
 If you know an application of this package, send a message to the author to add a link here.
| Related pages | 
| download excel file used to test this class | 
| PHP Doc |