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?
PHPExcel is the great library. I prefer to use it!
You can also take a look an example of this library on CodeIgniter here
I use PHPExcel at codeplex! They have great support there! Also it is very lightweight and has great documentation!
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With