Exporting Output text to Excel
13 views (last 30 days)
Show older comments
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
0 Comments
Answers (1)
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
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..
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!