Difficulty importing dates using readtable
1 次查看(过去 30 天)
显示 更早的评论
I'm trying to read some dates into matlab to do arithmetic with. The excel looks like this

right now, I'm trying
uRiDdD = readtable('filename.xls', 'datetime','%{d-MMM-y}D,%f%f%f');
but I get the following error:
Error using readtable (line 197)
Expected input to match one of these values:
'text', 'datetime', 'exceldatenum'
The input, '%{d-MMM-y}D,%f%f%f', did not match any of the valid values.
0 个评论
采纳的回答
dpb
2019-5-25
The file doesn't match the format string -- it has a numeric value followed by two dates and who knows what else afterwards and you told it there was one date followed by three floating point values. Clearly that won't work...should be no mystery there.
First, unless the file is huge, just let readtable operate on its own; you have unambiguous date formats, it should have no issues interpreting the input unless there are ambiguities elsewhere in the file.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!