How to import excel sheet with Dates/Time in the first column
16 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (2)
Sudhakar Shinde
le 10 Oct 2020
2 commentaires
Sudhakar Shinde
le 12 Oct 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
le 12 Oct 2020
2 commentaires
Walter Roberson
le 12 Oct 2020
date_for_plots = datetime(DATA(:,1), 'convertfrom', 'excel');
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!