Welcome Guest, Not a member yet? Register   Sign In
date excel
#1

[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
#2

[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.
#3

[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
#4

[eluser]elrolfe[/eluser]
Smile
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.




Theme © iAndrew 2016 - Forum software by © MyBB