How to: write .xls into a dynamic folder name ?

Question

John Doe 2020-12-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/672508-how-to-write-xls-into-a-dynamic-folder-name

评论： John Doe 2020-12-2

采纳的回答： Walter Roberson

在 MATLAB Online 中打开

Hello everyone,

It may be a silly question for you all folks, but i'm kick in a teeth on that one...

First the code and then what i want to do.

Prompt={'Nom', 'Surname', 'Birth_date (mm dd aaaa)','Evaluation_date (mm dd aaaa)'};
Dlgtitle=' patient data';
Def={'Duarte','Mickaels','01 01 2000','16 02 2018'};
Answer=inputdlg(Prompt,Dlgtitle,1,Def); 
Patient_info={Answer{1},Answer{2},Answer{3}};
Eval_date={'Evaluation',Answer{4}}; 
Muscle={'Fl_Pr','Ex_Su','Bic','Tri'}; 
Task=[1;2;3;4;5;6]; 
Task1={'Task'};
mkdir ([Answer{1},' ',Answer{2},' ',num2str(Answer{3})]) % create folder with data from the prompt Patient_info
xlswrite(???????????????.xls,Task,'Fpic','A5'));
xlswrite((???????????????..xls,Patient_info,'Fpic','A2'));
xlswrite((???????????????.,Eval_date,'Fpic','A3'));
xlswrite((???????????????.,Muscle,'Fpic','B4'));
xlswrite((???????????????.,Task1,'Fpic','A4'));

I'm trying to write an .xls into the folder i just created for each of my patients from the data i put in the prompt.

If someone can help...

Thanks you all !

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2020-12-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/672508-how-to-write-xls-into-a-dynamic-folder-name#answer_562343

编辑：Walter Roberson 2020-12-2

在 MATLAB Online 中打开

folder = [Answer{1},' ',Answer{2},' ',num2str(Answer{3})];
if ~exist(folder, 'dir'); mkdir(folder); end
filename = 'patient_data.xlsx';
fullname = fullfile(folder, filename);
xlwrite(fullname, Task, 'Fpic', 'A5');
xlswrite(fullname, Patient_info, 'Fpic', 'A2');