How to import dates so that MatLab sees them?

Question

Ekaterina Serikova 2016-6-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/289809-how-to-import-dates-so-that-matlab-sees-them

回答： Star Strider 2016-6-14

error.xlsx

Dear all, I know that that problem was widely discussed, but still none of the previous solutions work for me (( I have a table with column A consisting of the dates(please see Excel attached). When I import the table into MATLAB using:

[dates,big]=xlsread('ExcelName','Big','A2:AIF71'), I get 2 strange arrows with 54 rows...

Could you please help me in importing the table so that MATLAB interprets the date column properly?

Thanks a lot!

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

请先登录，再进行评论。

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

Answer 1

Star Strider 2016-6-14

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/289809-how-to-import-dates-so-that-matlab-sees-them#answer_225466

在 MATLAB Online 中打开

This works for me:

ExcelName = 'Ekaterina Serikova error.xlsx';
% [dates,big]=xlsread(ExcelName,'Big','A2:AIF71');          % Worksheet 'Big' Does Not Exist In Your File
[dates,big]=xlsread(ExcelName,'A2:AIF71');
DN = datenum(big);                                          % Using ‘datenum’
DN_Check = datevec(DN(1:5))
DT = datetime(big);                                         % Using ‘datetime’
DT_Check = DT(1:5)