Save data to Excel without overlapping
3 views (last 30 days)
Show older comments
A, a 3x2 variables that store 3 points detected.
B, variable to store angle of that 3 points.
A and B is in a for loop, since I detect many frames (around 400 frames).
How can I store A and B for all frames in two different excel files.
Excel filename for A: Coordinates.xlsx, B: Angle.xlsx
0 Comments
Accepted Answer
Sindar
on 27 Jun 2020
Check out writematrix: https://www.mathworks.com/help/matlab/ref/writematrix.html#mw_f36f6f84-e6bd-4749-8957-a88b07036116
Something like this should work:
writematrix(A,'Coordinates.xlsx','WriteMode','append')
writematrix(B,'Angle.xlsx','WriteMode','append')
10 Comments
Sindar
on 1 Jul 2020
Edited: Sindar
on 1 Jul 2020
Looking back at it, I realize that you probably want three thetas to a row. In that case, try this:
thetas=nan(1,length(stats));
for object=1:length(stats)
...
theta2=atan((AllCentroids(end,end)-AllCentroids(2,end))/(AllCentroids(end,1)-AllCentroids(2,1)));
theta=(abs((theta1-theta2)*(180/pi)));
%set the position of Angle display
p=10.0;
q=15.0;
t=text(theta,theta,strcat('Angle: ',[sprintf('%1.2f',theta),'{\circ}']),'FontName', 'Arial',...
'FontWeight', 'bold', 'FontSize', 12, 'Color', 'white');
set(t,'Position',[p q 0]);
thetas(object) = theta;
end
writematrix(thetas,'Angle.xlsx','WriteMode','append')
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!