Go4Expert

Go4Expert (http://www.go4expert.com/)
-   PHP (http://www.go4expert.com/forums/php/)
-   -   Import Excel data in to mysql with PHP (http://www.go4expert.com/forums/import-excel-data-mysql-php-t22994/)

dilip1030 11Aug2010 22:27

Import Excel data in to mysql with PHP
 
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

shabbir 11Aug2010 23:15

Re: Import Excel data in to mysql with PHP
 
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.

dilip1030 11Aug2010 23:29

Re: Import Excel data in to mysql with PHP
 
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.


All times are GMT +5.5. The time now is 18:19.