importing data with dates from excel
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
How to import data from excel spread sheet and preserve date format and time of day format
0 Kommentare
Antworten (1)
Azzi Abdelmalek
am 21 Aug. 2016
[~,~,data]=xlsread('yourfile')
1 Kommentar
Azzi Abdelmalek
am 21 Aug. 2016
Robert commented
Thank you.Unfortunately does not work. If I use 'import data' facility, the table is imported but under date column the title 'date' is replaced by NaN and the actual dates are converted to [Type:Number,value:nnnnn.0]. However, the other information in the table is imported and tabulated correctly.
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!