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.
댓글 수: 1
추가 답변 (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!