How to select multiple excel files with the uigetfile function?
12 views (last 30 days)
Show older comments
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 Comments
Answers (1)
Jon
on 24 Jan 2022
Edited: Jon
on 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 Comments
Jon
on 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
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!