How to select multiple excel files with the uigetfile function?

3 views (last 30 days)
enzo Boven
enzo Boven on 24 Jan 2022
Commented: Jon on 24 Jan 2022
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

Answers (1)

Jon
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
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

Sign in to comment.

Products


Release

R2016b

Community Treasure Hunt

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

Start Hunting!