How to Write Output Figure with Table inside to Excel

조회 수: 2 (최근 30일)
Murat Kocaman
Murat Kocaman 2018년 10월 8일
댓글: Murat Kocaman 2018년 10월 17일
I have an image output with a table on my code:
I am trying to export this result to an excel file which I create each save with figure and results table.
Could anyone assist on the issue?
I have already tried below:
writetable(table(result), 'Result.xlsx', 'WriteVariableNames', true) xlswritefig(gcf, 'Results.xlsx', 'Sheet1', 'D2')
This gave the error which indicates excel is not able to be created and much more.
  댓글 수: 6
Jan
Jan 2018년 10월 17일
편집: Jan 2018년 10월 17일
@Murat Kocaman: You ignore my questions for clarifications yet.
Murat Kocaman
Murat Kocaman 2018년 10월 17일
Sorry I missed that. My version is R2018a.

댓글을 달려면 로그인하십시오.

답변 (1개)

ANKUR KUMAR
ANKUR KUMAR 2018년 10월 8일
"I have an image output with a table on my code"
You can directly write this table in excel using xlswrite.
A=randi(10,5,6) %load your table in place of this command
xlswrite('sample.xlsx',A)
If you specifically wish to start writing with specific sheet and cell, then use this
xlswrite('sample.xlsx',A,'sheet1','A1')
  댓글 수: 1
Murat Kocaman
Murat Kocaman 2018년 10월 12일
xlswrite(filename,Value2,'Sayfa1','A2:A10000');
I used this one. It extract the table values but not figure.

댓글을 달려면 로그인하십시오.

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

제품

Community Treasure Hunt

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

Start Hunting!

Translated by