Plot data import from excel to figure use GUI ?
显示 更早的评论
Hello everyone!
I'm a beginer. and i want to study on GUI.
Now, i want to build a GUI such as: (see picture)
First, i want to click on "Import" button to import data from a excel file. And, i choise plot my data in "linear" or "dB", (1 dB = 20*log(x)), x is input data.
And, after i decided data in Y axes (vertical axes) is linear or dB depend on i click on "linear" or "Log". i will click on "draw" button to draw my data.
I wrote a code, but, it didn't run.
Please help me!
Thank you so much
This is my code: (i only show Callback functions)
function import_Callback(hObject, eventdata, handles)
handles.fileName = uigetfile('*.xlsx'); % imput mot file Excel
guidata(hObject,handles);
function draw_Callback(hObject, eventdata, handles)
filename = get(handles.import,'String');
values = xlsread(filename);
xCol = values(:,1);
yCol = values(:,2);
set(handles.truc,'Visible','on');
plot(handles.truc,xCol,yCol)
function linear_Callback(hObject, eventdata, handles)
set(handles.truc,'Scale','Linear');
function log_Callback(hObject, eventdata, handles)
set(handles.truc,'Scale','Log');
4 个评论
Adam
2018-12-17
What do you mean by 'It didn't run'? Do you get an error? If so what is the error? If not then what does happen? Nothing at all?
Adam
2018-12-17
You need to get the YAxis from your axes and set 'Scale' on that. It isn't a property of the axes, at least not in recent versions of Matlab. You didn't include your version so I don't know which you are using.
e.g.
handles.truc.YAxis.Scale = 'Log'
or the equivalent for XAxis if you want the x axis logarithmic
Le Dung
2018-12-17
Yes. When i click on "Run" to run this code.
Program will run, and, i click on "Import" button. then, i can choise a file excel because i used a uigetfile command. and i cilck on open this excel file.
And then, i click on "linear" or "log". And finally, i click on "Draw" button, matlab return:
Error using xlsread (line 128)
XLSREAD unable to open file 'Import'.
File 'Import' not found.
Error in vefrf>draw_Callback (line 89)
values = xlsread(filename);
Error in gui_mainfcn (line 95)
feval(varargin{:});
Error in vefrf (line 42)
gui_mainfcn(gui_State, varargin{:});
Error in @(hObject,eventdata)vefrf('draw_Callback',hObject,eventdata,guidata(hObject))
Error while evaluating UIControl Callback
I think may be "xlsread" command didn't realized filename variable.
Luna
2018-12-17
Are you sure on that line values = xlsread(filename); filename is the full file name with its path like: 'C:\users\....\example1.xls' ?
采纳的回答
Geoff Hayes
2018-12-17
The problem may be with this code
function draw_Callback(hObject, eventdata, handles)
filename = get(handles.import,'String');
values = xlsread(filename);
xCol = values(:,1);
yCol = values(:,2);
set(handles.truc,'Visible','on');
plot(handles.truc,xCol,yCol)
Is handles.import the handle to your Import button? And so when you read the string (from it) you are then trying to open a file named "Import"? The import_Callback saves the name of the file to handles.fileName so your above code should be
function draw_Callback(hObject, eventdata, handles)
if isfield(handles, 'fileName')
filename = get(handles.fileName);
values = xlsread(filename);
xCol = values(:,1);
yCol = values(:,2);
set(handles.truc,'Visible','on');
plot(handles.truc,xCol,yCol)
end
As Luna has indicated, make sure that handles.filename includes the full path to your file. You may need to change the import callback code to
[file, path] = uigetfile('*.xlsx');
handles.fileName = fullfile(file, path);
guidata(hObject,handles);
更多回答（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 
