Importing Excels sheets into app desinger

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;

Answer 1

[Cris LaPierre]

The importdata function does not have an input for specifying 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);