Display row from Excel file in Matlab

Question

Javier 2020-7-18

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/567234-display-row-from-excel-file-in-matlab

评论： Javier 2020-7-19

采纳的回答： Cris LaPierre

在 MATLAB Online 中打开

Hello there, I am trying to generate a random number (n) to then look for the data in the row n in a Excel file.

When I used

X = readtable('file.xlsx')

instead of

X = importdata('file.xlsx')

the program worked fine, but I want to know how to make it work with the function importdata as well.

It gives me this error Index in position 1 exceeds array bounds (must not exceed 1).

This is the code I used:

X = importdata('file.xlsx')
n = input('Number of participants:    ');
r = randi(n)
disp('The winner is:    '+string(r))
disp('The winner data is:   ')
disp(X(r,:))

2 个评论
显示无隐藏无

Cris LaPierre 2020-7-18

Without knowing more about your file, we can't offer much help. The error message would suggest X only contains a single row. Check that X exists in your Workspace, and is the expected size.

Javier 2020-7-19

It has 2 columns and 5 rows. In the first column are the numbers 1 to 5 and in the second column are names.

请先登录，再进行评论。

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

Answer 1

Cris LaPierre 2020-7-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/567234-display-row-from-excel-file-in-matlab#answer_467883

编辑：Cris LaPierre 2020-7-19

在 MATLAB Online 中打开

The error message you are seeing is because importdata returns the results in a stucture. Numeric data would be in X.data, text data in X.textdata. Also from the documentation:

For ASCII files and spreadsheets, importdata expects to find numeric data in a rectangular form (that is, like a matrix).

Tables allow you to mix data types in the same row. Here, you will need to build the disp command by combining the two separate structure fields. Perhaps something like this:

disp([X.data(r) X.textdata(r)])