How to import excel data into table GUI matlab

inggrid kinanti

2020 6 16

0 个回答

4 次查看（30 天）

0 个投票

Hi. I just knew Matlab.

I want to make a simple project that displays data in the GUI table after I press the browse button and

I'm having trouble importing this data from Excel into the GUI table. the excel data that I imported is not visible in the GUI table.

Could you help me correct my code for that? Thank you very much!

this is my code:

% --- Executes on button press in btnBrowse.
function btnBrowse_Callback(hObject, eventdata, handles)
proyek=guidata(gcbo);
[namafile,direktori]=uigetfile({'*.xls;*.xlsx','file excel(*.xls,*.xlsx)';'*.*','semua file(*.*)'},'buka file Excel');
alamatfile=fullfile(direktori,namafile);
set(handles.btnBrowse,'String','alamatfile');
[a,b,c]=xlsread(alamatfile);
bar=size(c,1);
col=size(c,2);
rnames=linspace(1,bar,bar);
data=c(:,1:col)
set(handles.tabel1,'Userdata',data);
guidata(hObject,handles);

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

Andrei Smoliakov 2020-6-17

That's because 'UserData' property is used not for table content, but for any custom user data associated with it. It can be used, for example, to share data between functions. For the displayed table content 'Data' property is used. You can read more about it in the "Table Properties" documentation page.