Import Excel data in to mysql with PHP

dilip1030's Avatar, Join Date: Jun 2010
Newbie Member
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
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
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.
0
dilip1030's Avatar, Join Date: Jun 2010
Newbie Member
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.