Recreate Matlab figure in Excel?
조회 수: 29 (최근 30일)
이전 댓글 표시
I am looking for a way to efficiently convert Matlab plots to Excel plots, while preserving markers, colors, errorbars, etc.
I want to do this so that I can then export the Excel graph to Powerpoint and be able to animate it. Therefore I don't want to just paste a picture of the Matlab plot in an Excel sheet, I need it as an actual interactive plot in Excel.
I have tried to export the Matlab figure as a .emf file, and tried ungrouping it in Powerpoint, but it then ungroups the markers from the lines, and manually regrouping that would be a nightmare.
Very thankful for tips.
댓글 수: 0
답변 (1개)
Allen
2020년 1월 20일
You can always use ActiveX (this will be phased out in a future version of MATLAB) to build plots directly in your Excel file. However, this can be difficult to program and slow to execute. Since you are ultimately trying to import a video into Powerpoint, you might want to try considering using VideoWriter() and getframe() to capture plots as frames (images) and compiliing them into an AVI using writeVideo().
v = VideoWriter(filename,'Motion JPEG AVI');
for i=1:Number_of_Frames
plot(X,Y)
frame = getframe(gcf);
writeVideo(v,frame)
end
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!