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;
采纳的回答
Cris LaPierre
2021-2-27
编辑：Cris LaPierre
2021-3-30
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);
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
