• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
date excel

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

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.

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.


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-2021 MyBB Group.