How to import excel sheet with Dates/Time in the first column
7 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Hello,
In the first column I have the dates written as 01.12.2019 00:00 in the other column I have datas as floating numbers.
If I import the excel sheet with "Data=xlsread('Filename') " I don't get the dates and times in the first column instead some random floating numbers.
I need the dates to make a graph with them on the X axis.
please help
2 Kommentare
Antworten (2)
Sudhakar Shinde
am 10 Okt. 2020
2 Kommentare
Sudhakar Shinde
am 12 Okt. 2020
[~,~,raw] = xlsread(filename);
%Extract date column if date is 2 nd column in excel
Date = raw(:,2);
%ignore Date header
Date = raw(2:end,2);
Giancarlo Meccariello
am 12 Okt. 2020
2 Kommentare
Walter Roberson
am 12 Okt. 2020
date_for_plots = datetime(DATA(:,1), 'convertfrom', 'excel');
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!