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

4 次查看(过去 30 天)
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 个评论
Dyuman Joshi
Dyuman Joshi 2022-8-23
The code you have showed us is incomplete
- There are no a, b anc c values defined/assigned.
- You have not initiated a loop counter nor is the loop counter updating according to conditions.

请先登录,再进行评论。

采纳的回答

Dyuman Joshi
Dyuman Joshi 2022-8-23
编辑:Dyuman Joshi 2022-8-23
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 个评论

请先登录,再进行评论。

更多回答(1 个)

Abderrahim. B
Abderrahim. B 2022-8-23
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 个评论
Dyuman Joshi
Dyuman Joshi 2022-8-23
编辑:Dyuman Joshi 2022-8-23
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.

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 Data Import from MATLAB 的更多信息

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by