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.