Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

Import Excel (.xls) data into mysql database

Codes here !

Moderators: macek, egami, gesf

Import Excel (.xls) data into mysql database

Postby minipop4747 » Thu Sep 06, 2012 7:43 pm

I want to code one php page, which import MS Excel (.xls) file data into Mysql database.

Procedure will be browse a excel file, when click button it will insert excel data into Mysql database

Can anyone help me to write this code

NOTE : I do not want to import .csv file only .xls file
minipop4747
New php-forum User
New php-forum User
 
Posts: 1
Joined: Thu Sep 06, 2012 7:32 pm

Re: Import Excel (.xls) data into mysql database

Postby johnj » Fri Sep 07, 2012 12:34 am

you can use a lib like phpexcel reader - http://sourceforge.net/projects/phpexcelreader/
johnj
php-forum Super User
php-forum Super User
 
Posts: 1805
Joined: Thu Mar 10, 2011 5:07 pm


Return to mySQL & php coding

Who is online

Users browsing this forum: No registered users and 2 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.