Clear Filters
Clear Filters

How to select a specified value into a matrix using readtable

1 view (last 30 days)
hi everyone, i'm using readtable function to get data from excel in this way:
matrix = readtable('sala_prove.xls');
now i have to select a specified row, for example
row = matrix(4,:);
at this point i should to select again a specified value, for example the first one of the row that i have just selected:
row(1)
but it doesn't work. there's an error message "You can not subscript a table using only one subscript. Table subscripting requires both row and variable subscripts." what does it mean? how can i resolve to select the first (or anyother) value in the row?

Answers (1)

Walter Roberson
Walter Roberson on 18 Sep 2015
row = matrix(4,:); selects a single row, but the result is still a table. You can use
row = matrix{4,:};
to extract the values.
  1 Comment
Daniele Morello
Daniele Morello on 18 Sep 2015
oh thanks, it can be a solution. but if i need the entire row using
row = matrix(4,:)
and then explore this table (isn't now an array?), how can i extract the values?

Sign in to comment.

Categories

Find more on Matrices and Arrays in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!