Welcome Guest, Not a member yet? Register   Sign In
Definitive library/helper to READ and Excel file in CI 2.0.2?
#1

[eluser]Beertastic[/eluser]
My brain is melting.
There's several posts with info on how to read an XLS file and output that data via PHP.
However many contain dead links or are for CI 1.7, I'm using CI 2.0.2.
EG: http://codeigniter.com/wiki/Excel_Reader_Class/ (NO link)

I am in need of a little help with this seemingly 'easy' task.

I have a VERY simple XLS file, no formatting and about 5 columns and no more than 50 rows. I need to scan each row and output that data to an array.

All the options I've seen online have heaps of code for writing to an XLS file.
I don't want or need this.

Perhaps I'm being blonde, but I hope not..
Can anyone help, where Google has not?

Beertastic....
#2

[eluser]theprodigy[/eluser]
I realize the library says it's for an older version of CI, but have you tried using it anyway?
What happens when using that library? What errors do you get?
#3

[eluser]Beertastic[/eluser]
There's no link to download it though... unless you have the link?
#4

[eluser]theprodigy[/eluser]
no, you are right. I don't see one either, and the forum thread link appears to either be incorrect, or points to a dead thread.
#5

[eluser]Beertastic[/eluser]
So, back to the drawing board... Is there a CI xls reader out there that I'm unaware of?
#6

[eluser]Clooner[/eluser]
XLS file reading seems a bit problematic anyway when I used it. Can't you simply save the excel as csv and process that?
#7

[eluser]Beertastic[/eluser]
I was told at the beginning that I couldn't.. however, i've just been told that I can! Smile
Bit of a waste of a day and a half.. but hey, I did learn stuff.. so that's nice...

cheers all!
#8

[eluser]carlos[/eluser]
Hey, I have the same problem, but I still cannot use csv files!

Any information out there?
#9

[eluser]Mirge[/eluser]
http://phpexcel.codeplex.com/

This is what I use when I need to read Excel files. Pretty straight-forward, just read through the documentation. It is not CI-specific.




Theme © iAndrew 2016 - Forum software by © MyBB