how to save data into same excel sheet after each iteration
조회 수: 4 (최근 30일)
이전 댓글 표시
HI
i want to store data (matrix form, X_dim = 1200x49 and Y_dim = 1200x49) from my current MATLAB program into an excel sheet.
Then for the next iteration i want to save the data in same sheet from row 1201.
can anyone help please. I saw several answers but i am confused.
댓글 수: 1
dpb
2021년 2월 14일
You'll have to keep track of the row number that you need for the 'Range' value each iteration.
compose may be of interest/help in creating that output range string from the current calculated number.
답변 (1개)
Jeremy Hughes
2021년 2월 15일
You can try writetable/writecell/writematrix with the 'WriteMode','append' parameter.
e.g.
writetable(myTable,'file.xlsx','WriteMode','append')
This is a fairly recent addition though. Not sure which release.
댓글 수: 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!