Readtable error help?

120 次查看（过去 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 中查找有关 Entering Commands 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by