Exporting Output text to Excel

20 ビュー (過去 30 日間)
John  Bowling
John Bowling 2016 年 6 月 22 日
コメント済み: Shameer Parmar 2016 年 6 月 22 日
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

回答 (1 件)

Shameer Parmar
Shameer Parmar 2016 年 6 月 22 日
xlswrite('ABC.xlsx',{'Your batting average is 0.357'},'Sheet1','A1');
and to open that xlsx file..
winopen('ABC.xlsx');
  2 件のコメント
John  Bowling
John Bowling 2016 年 6 月 22 日
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 2016 年 6 月 22 日
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..

サインインしてコメントする。

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by