importing data with dates from excel
Show older comments
How to import data from excel spread sheet and preserve date format and time of day format
Answers (1)
Azzi Abdelmalek
on 21 Aug 2016
[~,~,data]=xlsread('yourfile')
1 Comment
Azzi Abdelmalek
on 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.
Categories
Find more on Dates and Time in Help Center and File Exchange
on 21 Aug 2016
on 21 Aug 2016
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
