I have seen it somewhere. Cannot really remember where. Think it was on an intranet application I was working on a while back. Perhaps you can find something in PHPClasses.org. Btw if you happen to tackle it I wouldnt mind seeing the result
Actually, I need one to read excel. In the past I’ve used the excellent Excel reader (http://sourceforge.net/projects/phpexcelreader) but I was just hoping that someone had already taken it and coded it up as a CI library.
Hmm looks like there is a tiny but strong template plugin for writing excel, i am sure i saw tiny but strong on the wiki. http://phpclasses.fonant.com/browse/package/3159.html
Not much help for your reading but might be of some use to somebody.
I’ve been working on making an Excel reader for CI, but it hasn’t been a high priority for me because I wasn’t sure if there was any demand for such a thing. If there are people who want one, maybe I will try to finish it soon.
I’ve been working on making an Excel reader for CI, but it hasn’t been a high priority for me because I wasn’t sure if there was any demand for such a thing. If there are people who want one, maybe I will try to finish it soon.
Derek is demanding! Actually I gave up on this myself a few months ago as I couldn’t find an acceptable open source tool, although I seem to remember there are commercial ones. I settled for using a csv export from Excel, rather than the .xls itself.
Actually, I need one to read excel. In the past I’ve used the excellent Excel reader (http://sourceforge.net/projects/phpexcelreader) but I was just hoping that someone had already taken it and coded it up as a CI library.
Thanks both.
Is that the one that is included with XAMPP? Cause it is pretty good.
Progress is proceeding, but a bit slower than I hoped. I’ve found all the documentation on the excel format that I need (thanks to openoffice.org), but it took me all weekend to fully understand it all. I’m almost to the point where I can read the data from a spreadsheet (just the data, not any formatting or formulas). Once I can pull the data into an array for easy access, I will release what I have. Other features, such as reading fonts and formatting and outputting the spreadsheet as html will take a bit longer. If there are any specific features you need for your project let me know and I will prioritize them.
Also, if someone could give me some tips on releasing code for CI, that would be helpful. I haven’t done this sort of thing before.
To anyone following this, here’s how I implemented a “stop gap” for reading xls files until a more elegant solution can be made.
1) I downloaded PHP-ExcelReader, and put the files into my root directory beside index.php.
2) In my controller I use
require('Spreadsheet_Excel_Reader.php'); $data = new Spreadsheet_Excel_Reader(); $data->setOutputEncoding('CP1251'); // Set output Encoding. $data->read($filename); // relative path to .xls that was uploaded earlier
I’ve finally finished the beta version of my spreadsheet reader library.
However, I’m not sure how to make it available for download. Can I add it to the CI wiki or is there a better way? It’s only one file, but I think its too much to copy and paste into a post. I’m still working on my personal website so that’s out. I guess if anyone wants it just let me know and I can email it? Sorry for the confusion, but I haven’t contributed any code here before.
