How to select multiple excel files with the uigetfile function?
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I used the uigetfile function in order to select excel files. I also used the Multiselect option, however when I run the program and need to select the excel files, it is not possible to select two or more excel files. While it is possible to select only one file. How can I fix this problem?
used script:
[file_list,path_name] = uigetfile('.xlsx','MulitSelect','on');
if iscell(file_list) == 0
file_list = {file_list};
end
for i = 1:length(file_list)
filename = file_list{i};
data_in = xlsread([path_name, filename]);
x_rf_raw = data_in(:,9); %9 relative xrf data else 1
y_rf_raw = data_in(:,10); %10 relative yrf data else 2
x_s_raw = data_in(:,12); %12 relative xs data else 5
y_s_raw = data_in(:,13); %13 relative ys data else 6
% analysis ....
end
0 commentaires
Réponses (1)
Jon
le 24 Jan 2022
Modifié(e) : Jon
le 24 Jan 2022
[file_list,path_name] = uigetfile('*.xlsx','MyDialog','MultiSelect','on');
You were missing the dialog name argument, so it was using 'MultiSelect' as the dialog name
2 commentaires
Jon
le 24 Jan 2022
If this answered your question, please accept the answer so others that have a similar question will know an answer is available
Voir également
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!