importing data with dates from excel

1 次查看（过去 30 天）
Robert Booth
Robert Booth 2016-8-21
评论： Azzi Abdelmalek 2016-8-21
How to import data from excel spread sheet and preserve date format and time of day format

请先登录，再回答此问题。

回答（1 个）

Azzi Abdelmalek
Azzi Abdelmalek 2016-8-21
[~,~,data]=xlsread('yourfile')
  1 个评论
Azzi Abdelmalek
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 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by