Re: ssconvert assumes that Excel/xlsx dates are in US locale?


In this case you do not have a csv problem, but an xlsx problem.

We read the file as per the file format specification and get a cell
with m/d/y format.  Unfortunately it looks like Excel doesn't follow
its own file format!  See, for example

It is not clear what they actually do and the answer may be locale
dependent.  I'll have to do some research.


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]