Problem reading excel dates with readtable on different computers

Question

Sagasen 2020-4-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/516925-problem-reading-excel-dates-with-readtable-on-different-computers

评论： darova 2020-4-10

Hello,

I have made a script on my computer to read dates from an excel file, dates are in the format 'dd/mm/yyyy hh:mm' in the excel file, and it works perfectly. But then i tried the same script in another computer which has a different language settings and now readtable is reading the excel dates as 'mm/dd/yyyy hh:mm' which is a problem for the later parts of the script. To make things worst i tried this same script in a third computer which is in the same local language as the first one but readtable reads the dates as 'dd.mm.yyyy hh:mm' which is also a problem because i have a datenum command right after and it fails cause the format is different.

So my question is if theres a way to read the excel dates always on the format 'dd/mm/yyyy hh:mm' even if i run the script on different computers with different languages and different punctuations? So i dont have to change the datenum command every time i run the script on a new computer.

Thanks

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

darova 2020-4-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/516925-problem-reading-excel-dates-with-readtable-on-different-computers#answer_425242

在 MATLAB Online 中打开

What about this smart approach?

mystr = '24/04/2020 11:12';
form = {'dd/mm/yyyy HH:MM'
        'mm/dd/yyyy HH:MM'
        'dd.mm.yyyy HH:MM'};
for i = 1:length(form)
    try
        datenum(mystr,form{i})
    catch exc
        sprintf('form %d is wrong',i)
%         rethrow(exc)
    end
end

4 个评论
显示 2更早的评论隐藏 2更早的评论

Sagasen 2020-4-10

Im not entirely sure, but i think it reads the excel raw data without the visualization of 'dd/mm/yyyy HH:MM' because it says it will work even if i dont have excel installed