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.

+12

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 - 7 years ago (2018-02-12) Reply

    test

    Ask clarification

    2 Recommendations

    Niger: Query MySQL to generate data exports

    This class can query MySQL to generate data exports.

    It can connect to MySQL using MySQLi and execute arbitrary queries.

    It can create CSV files with data from database query results and have the files split when they exceed a given number of lines.
    This recommendation solves the problem.
    This recommendation does not solve the problem.

    +1

    Picture of Hassane Moussa by Hassane Moussa package author package author Reputation 495 - 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 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.
    This recommendation solves the problem.
    This recommendation does not solve the problem.

    +3

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