How can DropDown Items dynamically obtain the name of different sheets in Excel instead of manually entering items?

Question

Jie Wu 2022-3-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1681724-how-can-dropdown-items-dynamically-obtain-the-name-of-different-sheets-in-excel-instead-of-manually

评论： Jie Wu 2022-3-28

If the items of dropdown are the names of multiple sheets of Excel, how to write the callback function is that the items are not written in by themselves, but obtained by importing Excel to read different sheets，Who can help me solve this problem, write a callback function or send a template？

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Simon Chan 2022-3-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1681724-how-can-dropdown-items-dynamically-obtain-the-name-of-different-sheets-in-excel-instead-of-manually#answer_927979

在 MATLAB Online 中打开

When you import the file, get the sheet names and put them as the 'Items' of the uidropdown.

sheetName = sheetnames(fullfile(pathname,filename));
% dd = uidropdown(uif,'Items',{''},'Value',{''});           % Assume original is empty
set(dd,'Items',sheetName,'Value',sheetName(1))

3 个评论
显示 1更早的评论隐藏 1更早的评论

Simon Chan 2022-3-28

在 MATLAB Online 中打开

Suppose your data in the excel sheets are all numeric data, you can use function readmatrix:

%uit = uitable(uif)                                                     % Don't know your uitable configuration 
uit.Data = readmatrix(fullfile(pathname,filename),'Sheet',dd.Value);    % Read the sheet choosen from the uidropdown