#22 Improvements

open
nobody
None
5
2009-05-27
2009-05-27
No

Improvements:
supports almost all formats of date, time, number, percentage, currency,
scientific notation generated by Microsoft Excel and OpenOffice (BrOffice).

support the following versions of xls files generated by Microsoft Excel and OpenOffice (BrOffice)
- Microsoft Excel 95
- Microsoft Excel 97
- Microsoft Excel 2003
- OpenOffice XLS Excel 5.0
- OpenOffice XLS Excel 95
- OpenOffice XLS Excel 97/2000/XP

"read" function returns false in case of failure

Discussion

  • File reader.php changed with the improvements

     
    Attachments
  • Hi,

    Can you help me to use the php file correctly. I am not getting a human readable string. See my code segment below.

    Thanks,
    Bk.

    Code:
    $myDate = $data->sheets[$sheet]['cells'][$row][$column];
    print $myDate;

    Output:
    39962.56

    Expected:
    29/05/2009

     
  • Hello,

    The value "39962.56" is the same as "29/05/2009" but in Excel format.

    If you are using the original file reader.php, there is a problem with some dates and numeric formats.

    The attached path fixes these problems, and add some improvements in the formatting of numbers and dates.