PHP Classes


Recommend this page to a friend!

      Native Excel Reader  >  All threads  >  Dates  >  (Un) Subscribe thread alerts  
Summary:Dates are wrongly retrieved
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

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

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:

BiffReader is interpreting them as:

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

Any ideas?