CodePlexProject Hosting for Open Source Software
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?
Yes -- iterate the cell data, use header cells as column names, create database tables as needed, insert into your database, etc.
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?
Are you sure you want to delete this post? You will not be able to recover it later.
Are you sure you want to delete this thread? You will not be able to recover it later.