Import XLSX in MATLAB using input() and xlsread()?

Hi, I am trying to create code for a script file in which Matlab's function input() is used to read the name of an excel file whose data is then read in using the function xlsread().

The thing I don't understand is why there is a need for input() when we have xlsread()?

My attempt is, however it doesn't open the XLSX file.

I think the input() part is vital, but how are these used together?

Thanks

xlsread(test.xlsx)

[Enrique]

Morning Sergio,

First thing you need to try is to enter your excel file as a string

Now you have

xlsread(test.xlsx)

And you would like

xlsread('test.xlsx')

Second thing is that matlab does not recommend xlsread anymore. Use readtable instead. Example:

T = readtable("patients.xls",ReadRowNames=true);
T(1:5,1:4)

Hope it helps, if you need anything else we can go further.

Best regards,

Enrique

[Sergio]

Thanks Enrique!!

Answer 1

[Dyuman Joshi]

You should use the more robust readmatrix or readtable.

There is no need for using input(). Directly specify the filename to the call -

data = readmatrix('test.xlsx')
%or
data = readtable('test.xlsx')

Refer to the documentation pages linked for more information.