Import ExcelSheet into MySql with PHP

Question

I have a problem with my project. i want to import Excel sheet directly into mysql database for PHP language without any conversion of Excel sheet into another format. i am very fed about this from last two weeks. So Please help me How I Do it. any expert please help me

Try searching in google first... U will find the first two links there itself... as first given by @Maor and other is http://rackerhacker.com/2008/11/07/importing-excel-files-into-mysql-with-php/ — OM The Eternity, Apr 16 '12 at 13:06
Do you mean that you want to store the actual Excel file itself in a database, or you want to store data from the Excel worksheets in a database table? — Mark Baker, Apr 16 '12 at 13:23
I want to store data from excel worksheet in a database.... actually a excel file which have 5 excel worksheets and i want to select 3 sheets to transform into database..... — Aamer Shahzad, Apr 16 '12 at 16:01
read sheet by sheet and store the data you want as you parse the file ! — pgratton, Apr 16 '12 at 17:47

score 2 · Answer 1 · edited May 23 '17 at 11:59

2

You can refer to this question: Reading an Excel file in PHP

Read the excel file using either PHPExcel or PHPExcel Reader (or any other preferred php lib...)

As you are reading the file, insert the data you read into your database.

edited May 23 '17 at 11:59

Community

1
1

answered Apr 16 '12 at 13:05

pgratton

663
4
14

Import ExcelSheet into MySql with PHP

1 Answers1