User input from an excel file

11 次查看（过去 30 天）
Kshitij D
Kshitij D 2017-3-7
评论： Kshitij D 2017-3-7
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.

请先登录，再回答此问题。

采纳的回答

Jan
Jan 2017-3-7
编辑：Jan 2017-3-7
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by