Skip to content

DateTimes in CSV are changed #14

@bean5

Description

@bean5

I mentioned an issue at SheetJS/sheetjs#1260 (comment), which from what I understand was only partially fixed. When I open the following CSV at http://oss.sheetjs.com, the times are removed from the DateTimes.

Input

"ID","TimeStamp"
1,"9/7/2018 10:52"

Output

| ID | TimeStamp |
|----|-----------|
| 1  | 9/7/2018  |

What is strange is that this only happens for CSV, not for XLSX files. If anything, I would expect the reverse. A CSV file to me is already as flat as data should get.

Admittedly, the main reason I mention this is because I ran into this on my own site. I attempted to work around it by specifying cellDates: true and raw: false, but those didn't work for me. Am I missing something? Is the above desired behavior?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions