Reading Multiple excel spreadsheets in MATLAB GUI
显示 更早的评论
Hi, I am new to MATLAB GUI. I have an excel workbook with already calculated parameters in column wise.Actually I have 16 different spreadsheets in this excel workbook.Now I want to make GUI in such a way that it takes 1 sheet at a time and provide the result.
I have already done with the first sheet and already made GUI Code and figure for this but i am facing problem in using all sheets on the demand of user and perform certain functions.
How can i use all the sheets at the same time based on user that which sheet it requires to have access to specific parameters.
Can anybody help me in this regard? Thank you
采纳的回答
I am not familiar with guide but xlsread reads one sheet at a time. You can get the number and name of sheets by xlsinfo and then load the requested sheet by xlsread.
[status,sheets] = xlsfinfo(filename); %Get sheets
selected_sheet=listdlg('ListString',sheets,'SelectionMode','single');
[num,txt,raw]= xlsread(filename,selected_sheet);
You can get selected_sheet from a gui listbox too I guess.
更多回答（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 
