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

14 次查看（过去 30 天）
Sergio
Sergio 2024-1-24
评论： Sergio 2024-1-24
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)
  2 个评论
Enrique
Enrique 2024-1-24
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

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Dyuman Joshi
Dyuman Joshi 2024-1-24
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.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2023b

Community Treasure Hunt

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

Start Hunting!

Translated by