How to import dates so that MatLab sees them?

1 次查看(过去 30 天)
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!

采纳的回答

Star Strider
Star Strider 2016-6-14
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)

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Data Import from MATLAB 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by