Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What PHP library/class could I use to read/write Excel file(s) [closed]

I am looking for a php library which supports accepting an excel file (like .xls or .xlsx) and then some sort of functionality to create an array populated with values of each column. (Separate arrays).

I know there might not be a read to use solution thus I thought about programming it. However, I was wondering which library could I use for several scenarios?

The few I cam across were

https://github.com/PHPOffice/PHPExcel

http://sourceforge.net/projects/phpexcelreader/

https://github.com/PHPOffice/PHPExcel

I have no idea which one use, though codeplex one seems to be most functional, but I don't want to use a too heavy php library and then not end up using 90% of the code.

Also depending of the framework which one could fit better?

like image 230
J D Avatar asked Jul 29 '13 18:07

J D


2 Answers

PHPExcel is the great library. I prefer to use it!

You can also take a look an example of this library on CodeIgniter here

like image 104
Erman Belegu Avatar answered Sep 23 '22 00:09

Erman Belegu


I use PHPExcel at codeplex! They have great support there! Also it is very lightweight and has great documentation!

like image 31
SkillSet Avatar answered Sep 25 '22 00:09

SkillSet