Info

Questa domanda è chiusa. Riaprila per modificarla o per rispondere.

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

1 visualizzazione (ultimi 30 giorni)
Nahir
Nahir il 1 Mag 2013
Chiuso: MATLAB Answer Bot il 20 Ago 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 Commenti
Matt Kindig
Matt Kindig il 1 Mag 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 il 1 Mag 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.

Risposte (0)

Questa domanda è chiusa.

Prodotti

Community Treasure Hunt

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

Start Hunting!

Translated by