import XLSX FILE and plot it in guide
1 回表示 (過去 30 日間)
古いコメントを表示
im trying to import ecxle file in the guide and plot it using one push bottom and 2 popupmene i used this code but it didnt work
handles.fileName=uigetfile('*.xlsx');
guidata(hObject,handles)
setPopupmenuString(handles.popupmenuX,eventdata,handles)
setPopupmenuString(handles.popupmenuY,eventdata,handles)
set(handles.popupmenuX,'callback','@(hObject,eventdata)project(''updateAxes'',hObject,eventdata,guidata(hObject))')
set(handles.popupmenuY,'callback','@(hObject,eventdata)project(''updateAxes'',hObject,eventdata,guidata(hObject))')
function setPopupmenuString(hObject,eventdata,handles)
fileName=handles.fileName;
[numbers,colNames]=xlsread(fileName);
set(hObject,'string',colNames);
function [x,y] = readExcelColumns(fileName,xCol,yCol)
% READEXCELCOLUMNS returns columns from .XLSX file
fileName='data.xlsx';
a=xlsread(fileName);
x=a(:,xCol); % make original Excel column into 'x'
y=a(:,yCol); % make original Excel column into 'y'
function updateAxes(hObject,eventdata,handles)
xColNum=get(handles.popupmenuX,'value');
yColNum=get(handles.popupmenuY,'value');
fileName=handles.fileName;
[x,y] = readExcelColumns(fileName,xCol,yCol);
plot (handles.axes8,x,y)
6 件のコメント
Rik
2019 年 4 月 18 日
"it didn't work"
There is a lot you can do with Matlab, but the mind reading toolbox is still in development. You need to explain what went wrong. What errors are you getting? Have you tried to use the debugging tools to find out at what line in your code the results are different from what you expect?
回答 (1 件)
Rik
2019 年 4 月 18 日
Now I realize what was the strange thing about your code: they are char arrays instead of function handles. In principle that is fine, but it has the effect of calling eval on that array, which doesn't run the function, but creates the handle you're seeing.
Your function doesn't actually ever run. The code below should fix this.
set(handles.popupmenuX,'callback',@(hObject,eventdata)project('updateAxes',hObject,eventdata,guidata(hObject)))
set(handles.popupmenuY,'callback',@(hObject,eventdata)project('updateAxes',hObject,eventdata,guidata(hObject)))
3 件のコメント
Walter Roberson
2019 年 4 月 19 日
編集済み: Walter Roberson
2019 年 4 月 19 日
Is there more detail about the error? For example, does it say that guidata is an unknown function or variable ?
Where are you storing something into handles.fileName ?
参考
カテゴリ
Help Center および File Exchange で Migrate GUIDE Apps についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!