MATLAB Answers

0

How to Write Output Figure with Table inside to Excel

Asked by Murat Kocaman on 8 Oct 2018
Latest activity Commented on by Murat Kocaman on 17 Oct 2018
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 Comments

Attach .mat file containing matlab table.
@Murat Kocaman: You ignore my questions for clarifications yet.
Sorry I missed that. My version is R2018a.

Sign in to comment.

1 Answer

Answer by ANKUR KUMAR on 8 Oct 2018

"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 Comment

xlswrite(filename,Value2,'Sayfa1','A2:A10000');
I used this one. It extract the table values but not figure.

Sign in to comment.