• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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.


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.