PHP Classes
elePHPant
Icontem

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

Recommend this page to a friend!
  All requests RSS feed  >  Import excel file (xlsx format) into ...  >  Request new recommendation  >  A request is featured when there is no good recommended package on the site when it is posted. Featured requests  >  No recommendations No recommendations  

Import excel file (xlsx format) into mysql database

Edit

Picture of Johann Conceicao by Johann Conceicao - Yesterday (2016-07-06)

I need to import excel data into database

This request is clear and relevant.
This request is not clear or is not relevant.

+1

Import excel file to a project wherein database used is mysql. Data must be displayed once it is selected from the database

Ask clarification

1 Recommendation

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

This recommendation solves the problem.
This recommendation does not solve the problem.

+1

Picture of Karl Holz by Karl Holz package author package author Reputation 110 - 14 hours ago (2016-07-06) Comment

This would be a good start to solving your problem, the index.php will show all the different views that this class exports. I have just updated it today.

If you need something to extend this for MySQL import I can make a new class that will build on top of this one; something like sheet per table, excel row for each MySQL table row. my Class has Cell Mapping already, I can add column mapping so your fields won't be A,B or C for each table.

Let me know what exactly you're thinking and I'll see what I can come up with, cool?

Recommend package
: 
: