フィルターのクリア

Problem with date fotmat from excel to Matlab

1 回表示 (過去 30 日間)
Guillermo Renderos
Guillermo Renderos 2018 年 3 月 19 日
コメント済み: Guillermo Renderos 2018 年 3 月 19 日
I'm working with a series of data imported to matlab from excel using the function xlsread. The data time format in excel is in dd/mm/yyyy HH:MM and I have alrady changed the format in the column of that parameter in the table that I'm using, so now the format says "Personalized". But when I open the same table in MatLab appears a number. I want to use the same format or change it to yyyy-mm-dd HH:MM but when I use the function datestr to change the number to a string, the dates are not the same (do not match with the excel ones) And when I use the syntax datestr(_, formatOut) and using the format I want, a error message appears. How can I do to fix my code or to be able to use the format I want.
  2 件のコメント
Von Duesenberg
Von Duesenberg 2018 年 3 月 19 日
Have you tried with the readtable function?
Guillermo Renderos
Guillermo Renderos 2018 年 3 月 19 日
Thanks!, that fix my problem.

サインインしてコメントする。

回答 (0 件)

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by