Cannot read date cell formate in Excel 2003 file

[cwtsui]

I have a file generated by Excel 2003. It only contain a column which is date. When I display it using the library, I can only see Integer. After checking the type of the cell is not Data and then cause error. please check

[djw]

Excel stores dates as integers — as3xls uses some heuristics to determine whether to convert the integer to a Date object. These must be giving the wrong answer for your file. Could you send me a link to the file?

Alternatively, take a look at the return values of the 'isDate' function:

http://github.com/djw/as3xls/blob/master/src/com/as3xls/xls/Formatter.as#L70

[raghu1286]

Hi, I am facing the same issue, while reading a date cell from excel I get a integer value but the Formatter.isDate method does not recognize it as a date value. Unless it tells me value is of date type I cannot convert it to date in actionscript. I have checked it on the latest code from the repository. Please help. Thanks.