Reading Multiple excel spreadsheets in MATLAB GUI

1 次查看（过去 30 天）
Ahmad Bilal
Ahmad Bilal 2018-10-10
评论： Ahmad Bilal 2018-10-11
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

请先登录，再回答此问题。

采纳的回答

Caglar
Caglar 2018-10-10
编辑：Caglar 2018-10-10
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by