How to specify a date string format when using xlsread from Excel?

1 次查看（过去 30 天）
Katherine Varga
Katherine Varga 2018-2-13
回答： Peter Perkins 2018-2-15
When I use xlsread to import dates, I receive the following warning: Warning: Successfully read the date/time strings using the format 'MM/dd/uuuu', but their format is ambiguous and could also be 'dd/MM/uuuu'. Specify a format string to avoid ambiguity.
How do I specify a date format when reading dates from Excel? I do not see an option to do so in xlsread.
  1 个评论
Jeremy Hughes
Jeremy Hughes 2018-2-13
Hi Kathrine,
Can you share some code? and a file? I'm not sure this is coming from XLSREAD. As far as I know, XLSREAD treats dates as text.
Jeremy

请先登录，再进行评论。

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

回答（2 个）

Katherine Varga
Katherine Varga 2018-2-14
Oh I see, it was coming from the datetime function I was using when converting the string I had imported from Excel. Thank you.
Peter Perkins
Peter Perkins 2018-2-15
Katherine, consider using readtable instead of xlsread. In recent versions, importing dates is much simpler than using xlsread.

类别

在 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