+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: date excel (/showthread.php?tid=22228)
date excel - El Forum - 09-01-2009
[eluser]Unknown[/eluser]
I use phpexcelreader. However phpexcel is
returning no match.
For example, i have value in cell 24/08/2009, but phpexcelreader always return 25/08/2009.
any one can help me
date excel - El Forum - 09-02-2009
[eluser]überfuzz[/eluser]
Not and answer about phpexcelreader!
I always use fgetcsv while working with excel files. Theres a nice set of functions that handles excel files. The excel file must be excel.csv.
date excel - El Forum - 09-02-2009
[eluser]elrolfe[/eluser]
might be a bug if the files have been cerated with excel on a mac. theres a 1-day offset in mac-excel-files. afaik dates in excel are represented by counting the days since (dont know since when), but they both start counting days on a different day.
try adding or subtracting one day, if thats possible in your case.
cheers
date excel - El Forum - 09-02-2009
[eluser]elrolfe[/eluser]
ok i was slightly wrong, you find it better explained here: http://www.lithoglyph.com/blog/archives/198
but it`s basically not a problem of phpexcelreader.