SUBSCRIBE VIA RSS


Subscribe to our feed

Symfony Experts

Symfony Experts
If you have an urgent question for a symfony-related issue, this is the place to ask.

Topics

Stack Overflow


The old fashioned way

RECENT TUNES

July 29, 2009 – 5:51pm PHP import excel (xls) files to array or csv

How have I never seen this before today?

PHPExcel

I’ve only been working with it for a few hours but it’s amazing. It can read and write from many different formats.

Output your spreadsheet object to different file formats

  • Excel 2007 (spreadsheetML)
  • BIFF8 (Excel 97 and higher)
  • PHPExcel Serialized Spreadsheet
  • CSV (Comma Separated Values)
  • HTML
  • PDF

Read different file formats into your spreadsheet object

  • Excel 2007 (spreadsheetML)
  • BIFF5 (Excel 5.0 / Excel 95), BIFF8 (Excel 97 and higher)
  • PHPExcel Serialized Spreadsheet
  • CSV (Comma Separated Values)

I am very excited about this. Another honorable mention is php-excel-reader which might be worth a look if you just want something a bit more simple.

Posted by in  Web Development   |  

2 Responses to PHP import excel (xls) files to array or csv

  1. William says:

    Thanks for the heads up on this, I was looking for something like this as well. I used to have another commercial script that did this but it doesn’t read the new native Excel spreadsheets for some reason.

  2. Sagiv says:

    thanks for sharing this info , it helped a lot!