I am receiving this error : Subscripting a table using linear indexing (one subscript) or multidimensional indexing (three or more subscripts) is not supported.

4 views (last 30 days)
When i try to run this code I'm receiving this error:
Subscripting a table using linear indexing (one subscript) or multidimensional indexing (three or more
subscripts) is not supported. Use a row subscript and a variable subscript.
a(1:11) %Imported data from excel
b(1:11) %Imported data from excel
c(1:11) %Imported data from excel
Resultant = sqrt(a*a + b*b + c*c);
Up = 180*atan2(a, sqrt(b*b + c*c))/pi;
Right = 180*atan2(b, sqrt(a*a + c*c))/pi;
while (0 < n < 11)
if (0 < Up || Right > 30)
disp('Fall is detected')
else
disp('No fall')
end
end
  2 Comments

Sign in to comment.

Accepted Answer

Dyuman Joshi
Dyuman Joshi on 23 Aug 2022
Edited: Dyuman Joshi on 23 Aug 2022
a = readmatrix('a.xlsx');
b = readmatrix('b.xlsx');
c = readmatrix('c.xlsx');
%I have not suppressed the outcome so you can verify the values of a
%as the first value will be read as NaN (not a number)
a = a(2:11) %Imported data from excel
a = 1×10
-2.3000 -2.6000 -2.4000 -2.9000 -3.6000 2.9000 3.0000 3.6050 3.9800 2.0350
b = b(2:11); %Imported data from excel
c = c(2:11); %Imported data from excel
Resultant = sqrt(a.*a + b.*b + c.*c);
Up = 180*atan2(a, sqrt(b.*b + c.*c))/pi
Up = 1×10
-23.0245 -31.4445 -33.6392 -53.8149 -61.2833 51.4768 67.9266 53.7637 46.6764 33.7866
Right = 180*atan2(b, sqrt(a.*a + c.*c))/pi
Right = 1×10
-25.1592 -34.1804 -36.8788 -24.6751 -14.0999 -3.0929 -21.7576 -30.9710 -30.7839 -47.5465
%since there are 10 elements in the arrays, the index should go from 1-10
n = 1;
while (n < 11)
if (0 < Up(n) | Right(n) > 30)
disp('Fall is detected')
break %breaking the loop
else
disp('No fall')
end
n = n+1;
end
No fall No fall No fall No fall No fall
Fall is detected
  8 Comments

Sign in to comment.

More Answers (1)

Abderrahim. B
Abderrahim. B on 23 Aug 2022
Hi!
We don't import data from excel that way.
In your case better to use readmatrix:
A = readmatrix(yourFile.xlsx) ;
If you want to have the data as table use readtable:
tbl = readtable(yourFile.xlsx) ;
Hope this helps
  5 Comments
Dyuman Joshi
Dyuman Joshi on 23 Aug 2022
Edited: Dyuman Joshi on 23 Aug 2022
Since you are looking to compare individual values, make this change
%replace
if (0 < Up | Right > 30)
%with
if (0 < Up(n) | Right(n) > 30)
and adjust the loop counter accordingly.

Sign in to comment.

Products


Release

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by