Exporting Output text to Excel

24 views (last 30 days)
John  Bowling
John Bowling on 22 Jun 2016
Commented: Shameer Parmar on 22 Jun 2016
How can i export the output line of MATLAB into a cell in excel? Say for example my output ans line says:
"Your batting average is 0.357"
How can i export that entire text into cell A1 in excel?
Thanks -John

Answers (1)

Shameer Parmar
Shameer Parmar on 22 Jun 2016
xlswrite('ABC.xlsx',{'Your batting average is 0.357'},'Sheet1','A1');
and to open that xlsx file..
winopen('ABC.xlsx');
  2 Comments
John  Bowling
John Bowling on 22 Jun 2016
Is there a way to automate this task? I dont want to type the output each time, rather i want to write it in a script and export multiple outputs. All without typing the actual output?
Shameer Parmar
Shameer Parmar on 22 Jun 2016
yes, you can create .m file for this command and add you logic for calling all your file one by one and writing the data in it.
so once you run this .m file, it will do the task automatically.
if you finding difficulty in creating .m file, let me know your requirement, I will help you..

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!