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



Thanks.

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
https://social.msdn.microsoft.com/Forums/office/en-US/e27aaf16-b900-4654-8210-83c5774a179c/xlsx-numfmtid-predefined-id-14-doesnt-match?forum=oxmlsdk

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

M.


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