How to write a char variable as filename in xlswrite

6 次查看（过去 30 天）
Eric Jenkins
Eric Jenkins 2018-6-21
评论： Eric Jenkins 2018-6-21
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')

请先登录，再回答此问题。

采纳的回答

Greg
Greg 2018-6-21
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 个评论
Greg
Greg 2018-6-21
Further, you probably want some input validation before calling xlswrite. What if the user types invalid filename characters or nothing at all?
Eric Jenkins
Eric Jenkins 2018-6-21
I was close! Just a bracket in the wrong spot, thank you very much. I'll also keep the validation step in mind for executing the code.
Thanks again!

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by