Import Excel data in to mysql with PHP

Newbie Member
11Aug2010,22:27   #1
dilip1030's Avatar
Can somebody send me PHP code which will read an excel file and write the data of that excel file into database. It should also read multiple tabs of that excel file and perform the same operation.

Thanks
Go4Expert Founder
11Aug2010,23:15   #2
shabbir's Avatar
Try http://phpexcel.codeplex.com/

Just curios as to why do you need the Code in PHP? You can export Excel content in CSV file.
Newbie Member
11Aug2010,23:29   #3
dilip1030's Avatar
Well I could have done but what I need to do is I have to allow the user to upload an Excel file everyday and that data will be inserted in to the database. So as I cannot give the user access to PHPmyadmin or Cpanel I'm giving an option to him to upload the excel file through the interface that I'm developing currently.