Exporting MatLab generated values into Excel Spreadsheet
조회 수: 3 (최근 30일)
이전 댓글 표시
Hi all,
I am currently attempting to export the values I have calculated in MatLab into an excel spreadsheet so that I do not have to manually copy them one by one. However I am unsure of how to do it.
My current codes stores the values in a dataset as shown in the codes below:
HEADER= {'Mean'; 'Standard Deviation'; 'Smoothness'; 'Third Moment'; 'Uniformity'; 'Entropy'}
endVALUES = [aMean; aSD; aSmoothness; aThirdMoment; aUniformity; aEntropy];
data = dataset(HEADER, VALUES);
disp(data);
Basically I am supposed to populate the spreadsheet with values calculated from MatLab, and it would be perfect if there is a way to export the data I have into the next empty row of an Excel spreadsheet.
Would anyone point me in the right direction as to how I can export the values I have into Excel?
Best Regards
Guan Zhao
댓글 수: 0
채택된 답변
Image Analyst
2013년 2월 19일
Have you tried to use the xlswrite() function?
댓글 수: 2
Image Analyst
2013년 2월 19일
It can, but if you call it more than 2 or 3 times it will be slow because each time it has to launch and shutdown Excel. In that situation you can either accumulate all your strings and numbers into one cell array and write it once, or else use ActiveX, for which I've posted demos here before.
추가 답변 (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!