MATLAB: Getting Pop-up menu output as Excel sheet for plotting

excel

hi everyone,

i am creating a gui which will help to compare the data from two selected sheets of excel file via plotting, excel file consist of various sheets. i am using one pusbutton for importing the excel file and two popup menu button for selection of two desired sheets of excel file and finally one axes to plot the data. my problem is that when i select a particular sheet from popup menu its not getting selected as file.

Best Answer

Varun - I don't understand this line of code

data111=xlsread(handles.popupmenuX,' data11')

Why are you using the handle of the popupmenu (X) as the file name? In your initial code post, you are using a filename field from the handles structure. Why the change? Also, why are you putting data11 in quotes? (Again this differs from your initial code post...)

Related Solutions

MATLAB: Excel plotting using popup menu

Varun - when you import the data from the Excel file, you are doing

handles.data1=xlsread(filename, selectedsheet)
data1=handles.data1
set(hObject, 'data1')

where the data1 field of the handles struct is being created and set to the data from the file. This is fine but what you need to do next is to save this new field to the structure (right now, you are just updating a local copy)

handles.data1=xlsread(filename, selectedsheet)
guidata(hObject, handles); % <---- the updated handles object is now saved

The other two lines (the second which may throw an error if the data1 field is not a property of hObject) can be removed. So remove

data1=handles.data1
set(hObject, 'data1')

Then in the popupmenu6_Callback, you would access data1 via

if isfield(handles, 'data1')
    item=handles.data1(item_selected, 29)
end

The line get(handles.popupmenu1, 'data1') which is throwing the error, can be removed.

MATLAB: Setting popup menu strings from excel

I think you should update the popupmenu string from upload call back itself.

This will update the data on the poupmenu once the file is uploaded.

Best Answer

Related Solutions

MATLAB: Excel plotting using popup menu

MATLAB: Setting popup menu strings from excel

Related Question