Read the full article -- Read excel file and import data into MySQL database using PHPExcel in Mitrajit's Tech Blog
N.B. -
- 1. Sample excel file
- 2. After download, change the cell values and upload it again.
- 3. Do not increase or decrease number of columns of the excel file. Otherwise, although it will display the data from the excel file but it can't store data into database.