That sounds like the raw value, since dates aren't actually stored the way they are displayed (they're stored as a number, not a string).

Another issue is: the contents in the parsed array of array have '\0' inserted between every two characters.

That sounds like UCS-2 or some such unicode encoding , not like a bug

I suggest you try Spreadsheet::ParseExcel