Import xls with multiple sheet to mysql

Topics: Developer Forum, User Forum
Mar 14, 2013 at 9:51 AM
Edited Mar 14, 2013 at 9:51 AM
Hi Team,

I am very new to PHPExcel, Like to know this script supports importing the excel sheet data to a mysql.

Please guide me.

Mar 14, 2013 at 10:30 AM
Edited Mar 14, 2013 at 10:31 AM
Have you looked at any of the documentation yet, particularly the Reade documentation?

PHPExcel won't write a spreadsheet to a database for you; but it will let you write a script that reads the file, loop through each row of each worksheet, and build an SQL insert statement from the cell data that you can then insert into your database