How to Write Output Figure with Table inside to Excel

2 vues (au cours des 30 derniers jours)
Murat Kocaman
Murat Kocaman le 8 Oct 2018
Commenté : Murat Kocaman le 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 commentaires
Jan
Jan le 17 Oct 2018
Modifié(e) : Jan le 17 Oct 2018
@Murat Kocaman: You ignore my questions for clarifications yet.
Murat Kocaman
Murat Kocaman le 17 Oct 2018
Sorry I missed that. My version is R2018a.

Connectez-vous pour commenter.

Réponses (1)

ANKUR KUMAR
ANKUR KUMAR le 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 commentaire
Murat Kocaman
Murat Kocaman le 12 Oct 2018
xlswrite(filename,Value2,'Sayfa1','A2:A10000');
I used this one. It extract the table values but not figure.

Connectez-vous pour commenter.

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by