MATLAB: Importing Excels sheets into app desinger

app designerimporting excel data

I'm making an app and one part is importing a a table from excel to a table in matlab app designer. and the code i wrote up allows me to import an excel file put onlly if it has one sheet if not it won't work. I want to fix it so that with a numerical enter feild I can input a number then that sheet of that excel sheet will be imported.
[file,path,indx]=uigetfile;
filename=[path file];
I=importdata(filename);
app.t=I.data
app.s=I.textdata;
app.UITable.Data=app.t
app.UITable.ColumnName=app.s;

Best Answer

The importdata function does not have an input for spcifying Sheet. I suggest using readmatrix or readtable, which do allow you to specify which sheet to import using a number. Since you are already using importdata, readmatrix is probably the most similar to your current workflow.
I=readmatrix(filename,'Sheet',1);
Related Question