importing data with dates from excel
1 次查看(过去 30 天)
显示 更早的评论
How to import data from excel spread sheet and preserve date format and time of day format
0 个评论
回答(1 个)
Azzi Abdelmalek
2016-8-21
[~,~,data]=xlsread('yourfile')
1 个评论
Azzi Abdelmalek
2016-8-21
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.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!