PHP Classes

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 - 8 years ago (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.

+11

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

  • 1 Clarification request

  • 1. Picture of Rajeev Choudhary by Rajeev Choudhary - 6 years ago (2018-02-12) Reply

    test

    Ask clarification

    2 Recommendations

    Niger: Query MySQL to generate data exports

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

    0

    Picture of Hassane Moussa by Hassane Moussa package author package author Reputation 370 - 7 years ago (2017-05-01) Comment

    Bonjour Johann,

    Vous pouvez regarder le Package de la classe Niger (Query MySQL to generate data exports). Je suis disponible tout éclaircissement !!!

    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.

    +2

    Picture of Karl Holz by Karl Holz package author package author Reputation 120 - 8 years 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
    : 
    :