Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#43 xls date conversion error

open
nobody
None
5
2005-05-04
2005-05-04
Doug Henderson
No

the attached zip file contains an excel spreadsheet
which is not converted properly with command line:

xlhtml -xp:0 -csv well.xls

column I and J are displayed as integers. Both Excel
and Open Office Calc 1.9.79 (2.0 beta) display these
colums as dates in dd-mmm-yyyy format.

e.g. I3 is displayed as 29-feb-1960 in Excel and Open
office but output by xlhtml as 21975.

This problem also exists in xls2csv (part of catdoc).

Discussion

  • Doug Henderson
    Doug Henderson
    2005-05-04

    contains well.xls which illustrates problem.

     
    Attachments