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

2 ビュー (過去 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