Borrar filtros
Borrar filtros

Exporting Output text to Excel

17 visualizaciones (últimos 30 días)
John  Bowling
John Bowling el 22 de Jun. de 2016
Comentada: Shameer Parmar el 22 de Jun. de 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

Respuestas (1)

Shameer Parmar
Shameer Parmar el 22 de Jun. de 2016
xlswrite('ABC.xlsx',{'Your batting average is 0.357'},'Sheet1','A1');
and to open that xlsx file..
winopen('ABC.xlsx');
  2 comentarios
John  Bowling
John Bowling el 22 de Jun. de 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 el 22 de Jun. de 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..

Iniciar sesión para comentar.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by