How to import data into guide which uses a function I have created

2018 3 13
1 个回答
回答已采纳
更新时间：2018 3 13
1 次查看（30 天）

0 个投票

Hello is there a way to import excel data into a simple GUIDE i have created? I understand workspace data can only be accessed on a script but not a function, hence is there a way to import data in a gui and then pass the data into a function i have created to use the data? Thanks!

请先登录，再回答此问题。

 采纳的回答

KSSV
KSSV 2018-3-13

0 个投票

1. The workspace can be accessed by a function, provided you input the variable name of the data as a input to the function.
2. You can input the name of excel file with path to your gui and then read the file inside the gui function.

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Darren Koh
Darren Koh 2018-3-13
Thanks! I've tried the second method buy i received this error here.
Error in Sample3>popupmenu1_Callback (line 99)
raw.handles=raw;
And this is my code for the popupmenu
function popupmenu1_Callback(hObject, eventdata, handles)
% hObject handle to popupmenu1 (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
% Hints: contents = cellstr(get(hObject,'String')) returns popupmenu1 contents as cell array
% contents{get(hObject,'Value')} returns selected item from popupmenu1
items = get(hObject,'String');
index_selected = get(hObject,'Value');
item_selected = items{index_selected};
display(item_selected);
handles.index_selected = index_selected;
raw = xlsread('EQTDatabase.xlsx','B6:C9')
raw.handles=raw;
guidata(hObject, handles)
Can i know whats the problem?
KSSV
KSSV 2018-3-13
Why this line?
raw.handles=raw;
Excel file is read and data is loaded into variable raW already.
Darren Koh
Darren Koh 2018-3-13
Oh i see ok i have deleted that line already. But the gui is still not using the 'raw' variable and i dont get why. I have written my function in the push button code below.
function pushbutton1_Callback(hObject, eventdata, handles)
% hObject handle to pushbutton1 (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
storedvals = handles.storedvals;
index_selected = handles.index_selected;
print = 'None';
x = 0;
y = 0;
tableData = get(handles.uitable1, 'data');
storedvals(cellfun('isempty', storedvals)) = {0};
M=cell2mat(storedvals);
r=index_selected;
if M(1)~=0
t=1;
x=M(1);
p=1;
flag = eqtcompare3(r, t, p, x, y, raw);

请先登录，再进行评论。

更多回答（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