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:
But the script gets:
How could I fix this?
Thank you in advance
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.
|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.
|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.