Readtable error help?

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

[Sriram Tadavarty]

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]

Thanks. FY20 is the worksheet and I just tried the error remains.

Answer 1

[Guillaume]

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);

[Leon]

Many thanks!

Answer 2

[Agneyan Dileep]

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.

Answer 3

[ARUNIMA V S]

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

Answer 4

[Ellen]

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