How to import excel sheet with Dates/Time in the first column
8 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposte (2)
Sudhakar Shinde
il 10 Ott 2020
2 Commenti
Sudhakar Shinde
il 12 Ott 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
il 12 Ott 2020
2 Commenti
Walter Roberson
il 12 Ott 2020
date_for_plots = datetime(DATA(:,1), 'convertfrom', 'excel');
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!