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');

[Adam]

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]

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]

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]

Are you sure on that line values = xlsread(filename); filename is the full file name with its path like: 'C:\users\....\example1.xls' ?

Answer 1

[Geoff Hayes]

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);

[Le Dung]

yes. exactly, i want to get file name of the file excel that took into import_callback function.

and, my problem is using variables through callback functions