Clear Filters
Clear Filters

Info

This question is closed. Reopen it to edit or answer.

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

1 view (last 30 days)
Nahir
Nahir on 1 May 2013
Closed: MATLAB Answer Bot on 20 Aug 2021
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 Comments
Matt Kindig
Matt Kindig on 1 May 2013
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 on 1 May 2013
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.

Answers (0)

This question is closed.

Products

Community Treasure Hunt

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

Start Hunting!