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

TWITTER

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 in  Web Development   |     |  delicious  Digg

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

  1. 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.

    By William on Aug 15, 2009

  2. thanks for sharing this info , it helped a lot!

    By Sagiv on Sep 30, 2009

Post a Comment

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word