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

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？

Answer 1

[Simon Chan]

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))

[Jie Wu]

Thank you very much for your solution，One more question is how to display the data of items in UITable when I select different value in dropdown，I always report errors with “readtable”。

[Simon Chan]

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

[Jie Wu]

Good job! Thank you so much. It's admirable. Your method worked again！