Difficulty importing dates using readtable
显示 更早的评论
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.
采纳的回答
dpb
2019-5-25
0 个投票
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.
1 个评论
Jeremy Hughes
2019-5-26
Format also doesn't work with Spreadsheets, only text.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
