PHP import Excel into database xls xlsx

Question

I tried to search for some plugins to import Excel file into MySQL database  one of them is http   code google com p php-excel-reader   The tool is so powerful that it displays the entire excel content into html   However  I think I just need to read the Excel file and extract the contents  for example  into an array  and then write a SQL statement for entering into the database   Would there be any good codes and packages  Thanks

User · Answer

If you can convert  xls to  csv before processing  you can use the query below to import the csv to the database   load data local infile  FILE CSV  into table TABLENAME fields terminated by     enclosed by     lines terminated by   n   FIELD1 FIELD2 FIELD3

User · Answer

I wrote an inherited class    x000D   x000D   lt  php x000D  class ExcelReader extends Spreadsheet Excel Reader    x000D    x000D   function GetInArray  sheet 0    x000D   x000D     result   array    x000D   x000D     for  row 1   row lt   this- gt rowcount  sheet    row      x000D      for  col 1  col lt   this- gt colcount  sheet   col      x000D       if   this- gt sheets  sheet   cellsInfo    row   col   dontprint      x000D         val    this- gt val  row  col  sheet   x000D         result  row   col     val  x000D         x000D        x000D       x000D    return  result  x000D     x000D   x000D    x000D    gt  x000D   x000D   x000D    So I can do this    x000D   x000D   lt  php x000D   x000D    data   new ExcelReader  any excel file xls    x000D   print r  data- gt GetInArray     x000D   x000D    gt  x000D   x000D   x000D

User · Answer

Sometimes I need to import large xlsx files into database  so I use spreadsheet-reader as it can read file per-row  It is very memory-efficient way to import    lt  php        If you need to parse XLS files  include php-excel-reader     require  php-excel-reader excel reader2 php         require  SpreadsheetReader php          Reader   new SpreadsheetReader  example xlsx           insert every row just after reading it     foreach   Reader as  row                 db- gt insert  row           gt    https   github com nuovo spreadsheet-reader

User · Answer

This is best plugin with proper documentation and examples https   github com PHPOffice PHPExcel Plus point   you can ask for help in its discussion forum and you will get response within a day from the author itself  really impressive

User · Answer

If you save the excel file as a CSV file then you can import it into a mysql database using tools such as PHPMyAdmin  Im not sure if this would help in your situation  but a csv file either manually or programatically would be a lot easier to parse into a database than an excel file I would have thought   EDIT   I would however suggest looking at the other answers rather than mine since  diEcho answer seems more appropriate

[php] PHP import Excel into database (xls & xlsx)

Examples related to php

Examples related to excel

Examples related to import