Display row from Excel file in Matlab
5 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Javier
am 18 Jul. 2020
Kommentiert: Javier
am 19 Jul. 2020
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 Kommentare
Cris LaPierre
am 18 Jul. 2020
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.
Akzeptierte Antwort
Cris LaPierre
am 19 Jul. 2020
Bearbeitet: Cris LaPierre
am 19 Jul. 2020
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)])
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!