Info

此问题已关闭。 请重新打开它进行编辑或回答。

how do i export/save an .xls or .csv file interactively?

1 次查看（过去 30 天）
Nahir
Nahir 2013-5-1
关闭： MATLAB Answer Bot 2021-8-20
I have written a script to be used on many files with very similar structure. At the end I want to write/export/save a modified version of the file that I imported. I need to change the name of that exported file each time a new one is imported because I don't want it overwritten or appended.
Currently I am using the_ xlswrite_ function: xlswrite('new_file.xls', data);
I have tried using the input function in conjunction with xlswrite because "_input_" allows me to interactively type in a new name in the command window; however, I have not gotten this to work.
Ideally, if subject1 = the file that I'm importing, I would like the exported file to be subject1_modified. I have 20 subjects so would have 40 files when it is all said and done. The name change can be don interactively or within the script.
Any assitance/suggestions would be greatly appreciated. Thanks.
  2 个评论
Matt Kindig
Matt Kindig 2013-5-1
Just dynamically generate the desired Excel filename using sprintf() or similar.
%for example, suppose that the current file is stored in 'yourfile'
yourfile = 'subject1'
xlswrite( sprintf('%s_modified.xls', yourfile), data);
Nahir
Nahir 2013-5-1
Thank you very much, that worked well for my solution. Wasn't even aware of an sprintf fxn but i learn something new everyday.
Thanks again.

此问题已关闭。

回答（0 个）

此问题已关闭。

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by