importing data with dates from excel
显示 更早的评论
How to import data from excel spread sheet and preserve date format and time of day format
回答（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.
类别
在 帮助中心 和 File Exchange 中查找有关 Dates and Time 的更多信息
2016-8-21
2016-8-21
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
