Effacer les filtres
Effacer les filtres

Info

Cette question est clôturée. Rouvrir pour modifier ou répondre.

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

1 vue (au cours des 30 derniers jours)
Nahir
Nahir le 1 Mai 2013
Clôturé : MATLAB Answer Bot le 20 Août 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 commentaires
Matt Kindig
Matt Kindig le 1 Mai 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 le 1 Mai 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.

Réponses (0)

Cette question est clôturée.

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by