search

AshishJoshi-asj / php-excel-reader

Automatically exported from code.google.com/p/php-excel-reader
0 stars 0 forks source link

Problem while reading formatted date from cell #128

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Please see the attached sheet with Birthdate formatted
2. 5/15/1985 -> 15-May-1985 (formatted from excel sheet)
3.

What is the expected output? What do you see instead?
When i read the excel sheet, the output is 'd0576' instead of '5/15/1985',
Expected output should be '5/15/1985'

Please provide any additional information below.
Actual date entered in sheet is '5/15/1985'
Formatted birth date to '15-May-1985'
Output is 'd0576'

Original issue reported on code.google.com by tezurfri...@gmail.com on 30 Sep 2011 at 7:22

Attachments:

GoogleCodeExporter commented 9 years ago 
Mate that is an XLSX file, this library can only read the old XLS format. You 
need to use PHPExcel instead. 
http://phpexcel.codeplex.com/wikipage?title=Examples

Original comment by endar...@gmail.com on 2 Oct 2011 at 4:32