User input from an excel file

I want the program to prompt a dialog box asking the user to specify which file should be selected for a particular variable eg. in my case I want the user to give me and excel file (.xlsx) with info for the x coordinates for a grid system. After the user specifies the file, I want the program to read the excel file and echo print the data selected.

Answer 1

[Jan]

BaseDir = 'C:\Temp';  % Set as you need
[FileName, FilePath] = uigetfile('*.xlsx', ...
                  'Please choose an Excel file', BaseDir);
if isequal(filename, 0)
   disp('User aborted file choosing.');
   return;  % Assuming this is a function
end
File = fullfile(FilePath, FileName);
[Num, Txt, Raw] = xlsread(File);

Now it is not clear where the wanted values are found in the Excel file. I assume you find the values in a column of Num.

[Kshitij D]

Thanks