importing data with dates from excel
1 view (last 30 days)
Show older comments
How to import data from excel spread sheet and preserve date format and time of day format
0 Comments
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.
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!