|Import excel file (xlsx format) into ...
|Request new recommendation
by Johann Conceicao - 7 years ago (2016-07-06)
Import excel file to a project wherein database used is mysql. Data must be displayed once it is selected from the database
1. by Rajeev Choudhary - 6 years ago (2018-02-12) Reply
Vous pouvez regarder le Package de la classe Niger (Query MySQL to generate data exports). Je suis disponible tout éclaircissement !!!
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?