MATLAB: How to import Excel data in Matlab GUI

guiimporting excel data

I want to create a Push Botton with GUI and it loads an Excel file. I use this code:

function pushbutton1_Callback(hObject, eventdata, handles)
handles.fileName = uigetfile('*.xlsx');
guidata(hObject, handles);
fileName = handles.fileName;

But when I choose the Excel file, it doesn't load the data, I don't see them in the workspace.

Moreover if I want to create the plot of those data, I use plot(fileName)?

Best Answer

You can use following code to load and plot the data from excel file.

function pushbutton1_Callback(hObject, eventdata, handles)
handles.filename=uigetfile('*.xlsx');
guidata(hObject,handles);
filename=handles.filename;
values=xlsread(filename);
x=values(:,1);
y=values(:,2);
plot(x,y);
handles.xvalues=x;
handles.yvalues=y;
guidata(hObject,handles);

Function xlsread loads the data, but when the callback function completes, that workspace is no longer available.

If you want to access variables, you can save them to the handles structure, so that other callback functions can access these variables. Update handles structure using guidata.

Related Solutions

MATLAB: Unable to Plot from Excel

handles.fileName = fullfile(file, path);

That creates fileName as a character vector field inside handles.

    filename = get(handles.fileName);

If handles.FileName were a handle, then that would return a structure of public properties of the handle.

However, handles.FileName is not a handle, just a character vector. You just need

    filename = handles.fileName;

MATLAB: Plot data import from excel to figure use GUI

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

Best Answer

Related Solutions

MATLAB: Unable to Plot from Excel

MATLAB: Plot data import from excel to figure use GUI

Related Question