Importing Excels sheets into app desinger
2 views (last 30 days)
Show older comments
Kyle Koutonen
on 27 Feb 2021
Edited: Cris LaPierre
on 30 Mar 2021
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;
0 Comments
Accepted Answer
Cris LaPierre
on 27 Feb 2021
Edited: Cris LaPierre
on 30 Mar 2021
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 Comments
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!