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.
采纳的回答
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.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Translated by 
