# I need to pull data from an excel file ino MATlab which I made happen I was also able to pull values from the table but now I don't know how to use these values in my equation

2 views (last 30 days)
Oskar Kinat on 16 Feb 2022
Commented: AndresVar on 16 Feb 2022
% design the multiplication matrix
k = [ (cos(al))^2, (sin(al))^2, -sin(2*al) ; (sin(al))^2, (cos(al))^2, sin(2*al) ; .5*sin(2*al), -.5*sin(2*al), (cos(al))^2];
disp("The multiplication matrix is displayed below");
disp(k);
% now we multiply the matrix
I = k * [Ixx ; Izz; Ixz] ;
>> table2array(T ({'IxxB (slugft2)','IzzB (slugft2)','IxzB (slugft2)'}, {'a'}))
ans =
948
1967
0
>> table2array(T ({'Angle of attack, u\ (deg)'}, {'a'}))
ans =
5.4000
I pulled this values from my excel file but how do I use them in my "k" and "I" equation? I am sorry if thats an easy answer AndresVar on 16 Feb 2022
assign the output of table2array to a variable, btw cos and sin need angle in radians. for example:
al = table2array(T ({'Angle of attack, u\ (deg)'}, {'a'}))
Ib = table2array(T ({'IxxB (slugft2)','IzzB (slugft2)','IxzB (slugft2)'}, {'a'}))

### Categories

Find more on Tables in Help Center and File Exchange

R2020b

### Community Treasure Hunt

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

Start Hunting!