How to write a char variable as filename in xlswrite
6 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Eric Jenkins
am 21 Jun. 2018
Kommentiert: Eric Jenkins
am 21 Jun. 2018
I am attempting to use an input statement in a loop to prompt me to input the "Patient, Session, Trial" as a char, where it will then use that string to name the .xlsx file. For example, the PST input would be 'P1S1T1', so I want the output of the xlswrite to be 'P1S1T1.xlsx'. Is this possible within xlswrite? Or is there a better way to do this?
This is what I have been tinkering with, I am just unsure how to use the PST variable.
Thanks a bunch
PST = input('Patient, Session, EMG#: ','s'); %saves variable 'PST' as char
xlswrite([PST],'.xlsx',data,1,'A1')
0 Kommentare
Akzeptierte Antwort
Greg
am 21 Jun. 2018
xlswrite([PST],'.xlsx',data,1,'A1')
Passes '.xlsx' as the second input argument to xlswrite. You want to concatenate it with PST instead:
xlswrite([PST,'.xlsx'],data,1,'A1');
2 Kommentare
Greg
am 21 Jun. 2018
Further, you probably want some input validation before calling xlswrite. What if the user types invalid filename characters or nothing at all?
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!