Login   Register  
PHP Classes
elePHPant
Icontem

Dates

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

      Native Excel Reader  >  All threads  >  Dates  >  (Un) Subscribe thread alerts  
Subject:Dates
Summary:Dates are wrongly retrieved
Messages:4
Author:Dfu
Date:2010-12-06 18:08:40
Update:2012-02-02 15:39:12
 

  1. Dates   Reply   Report abuse  
Picture of Dfu
Dfu
2010-12-06 18:08:40
Hi,

First of all, thank you about this one. It's really fast and works :)

Just would need help on retrieving dates. My test.xls file has two fields with "date" format (dd/mm/YYYY) and below data:

01/12/2010 31/12/2010

But the script gets:

02.12.2010 01.01.2011

How could I fix this?

Thank you in advance

  2. Re: Dates   Reply   Report abuse  
Picture of Ruslan V. Uss
Ruslan V. Uss
2011-01-07 04:29:26 - In reply to message 1 from Dfu
Could you send me your test.xls?
I can't reproduce this bug.

  3. Re: Dates   Reply   Report abuse  
Picture of metron
metron
2011-02-21 20:44:43 - In reply to message 1 from Dfu
It will very helpful to know, which xls file version format (2004,2003, Excel97 or earlier, btw. only table or workbook) you use to grant this code properly to work. Only what I get was blank white screen without any results or exceptions. (using Excel2004, default test.xls workbook)

thx for help.

  4. Re: Dates   Reply   Report abuse  
Picture of Mat Beard
Mat Beard
2012-02-02 15:39:12 - In reply to message 3 from metron
Hi.

I'm also having this problem. All dates are formatted as dd/mm/yyyy in Excel i.e. UK date format. These are all advanced by one day when read with BiffReader.

This is not a massive problem because it's consistent and I can compensate for it with my code.

However, there are other problems...

I have a column with the following numbers:
2902888
2902888
3019022
3005672
2971643

BiffReader is interpreting them as:
-0.00067588128149509
-0.00067588128149509
3019022
-0.00069981254637241
2971643

I've tried formating them as numbers and text -- same result. File is Excel 2003 format.

Any ideas?