Import dates from an excel spreadsheet
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hello,
I need to import the attached data from an excel spreadsheet into matlab.
Column E represents the temperature values and column F represents the time values.
When I import the time values in excel with the Import Tool the result is decimal numbers.
Other pots I have read about explain how to convert a single entry into the correct time value but my question is how do I convert the whole time column into the desired values in format HH:MM:SS.
Many thanks.
0 commentaires
Réponses (1)
Guillaume
le 28 Mai 2019
One way to read that data:
opts = detectImportOptions('temperature.xlsx'); %ask matlab to detect the format of the file
opts.VariableTypes{2} = 'duration'; %override format of Time to duraiton
opts = setvaropts(opts, 'Time', 'DurationFormat', 'hh:mm:ss') %display duration as hh:mm:ss
tt = readtimetable('temperature.xlsx', opts)
Excel must do some rounding on the time that matlab doesn't do as some times are off by one second
0 commentaires
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!