Readtable error help?
131 views (last 30 days)
Show older comments
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 Comments
Sriram Tadavarty
on 22 Mar 2020
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?
Accepted Answer
Guillaume
on 22 Mar 2020
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);
More Answers (3)
Agneyan Dileep
on 28 Jul 2020
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.
0 Comments
ARUNIMA V S
on 14 Aug 2022
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
0 Comments
Ellen
on 18 Nov 2023
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
0 Comments
See Also
Categories
Find more on Entering Commands in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!