How to automically read data from excel file

Question

Chao Zhang 2021-5-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/835118-how-to-automically-read-data-from-excel-file

回答： Cris LaPierre 2021-5-20

I am newer to learn Matlab, so I would like to ask for some help.

I use 'menu' function to create 3 buttons, such as 'A', 'B', and 'exit the program', and I want to automically select and read the dataset of different excel files when users click button A or B, and users then can use the dataset in the workspace to do some computations.

For this purpose, i then create function A and function B respectively, the following example is function A:

function A(data, position)
%data.name is the appropriate excel file, pathname is the position of file
%specifies the type of file that can be selected
[data.filename, pathname]=...
    uigetfile({'*.xlsx';'*.xls';'*.*'},'File Selector');
pathname=string(pathname);
data.filename=string(data.filename);
if isequal(data.filename,0)||isequal(pathname,0)
    return
else
    data.fileText.Value=pathname+data.filename;
end