Reading Multiple excel spreadsheets in MATLAB GUI

조회 수: 3 (최근 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 CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by