New version of readtable does not load .csv file.

8 次查看（过去 30 天）

Raymond Ng 2022-2-3

2
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1642585-new-version-of-readtable-does-not-load-csv-file

编辑： Raymond Ng 2022-3-30

20210501_META_DASnode_enid_B.csv

I just upgraded from 2019a to 2021b and I cannot upload a .csv file that used to have no problem loading into Matlab. Readtable or similar end result would be preferred since I have many codes that use readtable. The .csv is an output from elsewhere so modifying it would not be feasible since it would require me to modify too many .csv files for current codes to work.

My current error is :

Error using readtable (line 498)

Invalid default value for property 'eol_' in class 'matlab.io.internal.shared.TextInputs':

Too many output arguments.

Error in Compare_node2DAS_PSD (line 11)

T = readtable('20210501_META_DASnode_enid_B.csv');

T=readtable('20210501_META_DASnode_enid_B.csv');

8 个评论
显示 6更早的评论隐藏 6更早的评论

Walter Roberson 2022-2-3

When I try that file in R2021b I get

Warning: The DATETIME data was created using format 'MM/dd/uuuu hh:mm:ss aa' but also matched 'dd/MM/uuuu hh:mm:ss aa'.

To avoid ambiguity, supply a datetime format using SETVAROPTS, e.g.

opts = setvaropts(opts,varname,'InputFormat','MM/dd/uuuu hh:mm:ss aa');

> In matlab.io.internal.readers/TextDataReader/read (line 102)

In matlab.io.internal.functions/ReadTableWithImportOptionsText/executeImpl (line 61)

In matlab.io.internal.functions/ReadTableWithImportOptions/executeImpl (line 25)

In matlab.io.internal.functions/ReadTableWithImportOptionsText/execute (line 66)

In matlab.io.internal.functions/ReadTableWithImportOptions/execute (line 45)

In matlab.io.internal.functions/ReadTable/execute (line 46)

In matlab.io.internal.functions/ExecutableFunction/validateAndExecute (line 102)

In readtable (line 495)

Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating variable names for the table. The original column headers are saved in the

VariableDescriptions property.

Set 'VariableNamingRule' to 'preserve' to use the original column headers as table variable names.

Raymond Ng 2022-2-9

Hi Walter,

You're correct. I moved the .csv into a new directory. I was able to use readtable! Thank you very much! Now I need to figure out what is interrupting my path.

Cheers!

Raymond Ng 2022-3-30

编辑：Raymond Ng 2022-3-30

The solution of moving to a new directory does not seem to work anymore. As I keep working on the script it will eventually throw up the same error. I'm very perplexed as to what is going on. I tried moving my script around to a new folder or up directory, but the same error keeps showing up. On a fresh new script it does seem to work until the error pops up then it will remain. Is there some hidden file that is appearing that is interrupting my path?

请先登录，再进行评论。

请先登录，再回答此问题。

回答（0 个）

请先登录，再回答此问题。

类别

MATLAB Environment and Settings

在 Help Center 和 File Exchange 中查找有关 Environment and Settings 的更多信息

产品

MATLAB

版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by