Readtable error help?

204 次查看（过去 30 天）
Leon
Leon 2020-3-22
回答： Ellen 2023-11-18
Here is my code and attached is my test.xlsx.
clear all
close all
clc
A = readtable('test.xlsx', 'FY20', 'PreserveVariableNames',true);
Why do I keep getting the below error:
Error using readtable (line 229)
All parameters must have an associated value.
Error in Generate_html (line 5)
A = readtable('test.xlsx', 'FY20', 'PreserveVariableNames',true);
Thanks
  2 个评论
Sriram Tadavarty
Sriram Tadavarty 2020-3-22
Seems like FY20 is not something part of readtable syntax. Can you try removing 'FY20' in the syntax and try, if you are looking for the same?
Leon
Leon 2020-3-22
编辑：Leon 2020-3-22
Thanks. FY20 is the worksheet and I just tried the error remains.

请先登录，再进行评论。

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

采纳的回答

Guillaume
Guillaume 2020-3-22
I suspect to your 'FY20' is meant to be the sheet name. Unlike xlsread, with readtable the sheet name is passed as a Name-Parameter argument:
A = readtable('test.xlsx', 'Sheet', 'FY20', 'PreserveVariableNames',true);

更多回答（3 个）

Agneyan Dileep
Agneyan Dileep 2020-7-28
Error using readtable (line 198)
All parameters must have an associated value.
Error in GTM (line 13)
T = readtable('Data Values.xlsx','Sheet','PreserveVariableNames',true);
I am also getting a similar error. Please help.
ARUNIMA V S
ARUNIMA V S 2022-8-14
clc
clear
data=readmatrix("2011-BC92.csv",2);
x=data(:,1);
y=data(:,2);
plot(x,y);
I'm also getting the same error .. please help
Ellen
Ellen 2023-11-18
I have the same error.
% scroll through file: how many lines are there?
v=readtable(filename,'%s%*[^\n]');
nlines=size(v,1); % total number of lines (including header)
those lines worked in a much older version

类别

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

标签

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by