Need to import excell into mysql database

Topics: User Forum
Jul 13, 2011 at 1:47 AM

I need to import excel files xlsx into mysql.  There my be over 1 million records.  These excel files are from reports generated by outside entities.  Using php 5.2.17.  Is there a way to do this with PHPExcel? 

Jul 13, 2011 at 3:06 PM

Yes -- iterate the cell data, use header cells as column names, create database tables as needed, insert into your database, etc.

Jul 13, 2011 at 7:40 PM

Okay, so how does that work using PHPexcel?

for php was going to use a post with multipart/form-data blah blah the $_Files array with fopen and fgetcsv. 

Is there an easier way with PHPexcel?