Export dan Import Excel Menggunakan MATLAB

function btnProses_Callback(hObject, eventdata, handles)

b1=get(handles.edBaris,'String');

b2=get(handles.edKolom,'String');

in1=str2num(b1);%double(b1)

in2=str2num(b2);%double(b1)

baris=in1;

kolom=in2;

y=randi(baris,kolom);

header= linspace(1,kolom,kolom);

row = linspace(1,baris,baris);

set(handles.myTablelp2mAray,'data',y,'ColumnName',header,'RowName',row);

set(handles.myTablelp2mAray,'Userdata',y);

function btnExport_Callback(hObject, eventdata, handles)

dt1=get(handles.myTable1,'Userdata');

filename = 'testdataex1.xls';

xlswrite(filename,dt1,1,'A1')

myicon(:,:,1) = [0 1; 0 1];

myicon(:,:,2) = [.8 1; 0 .3];

myicon(:,:,3) = [.3 0; .9 .5];

h=msgbox('Sukses Exsport','Success','custom',myicon);

IMPORT EXCEL

function btnBrowse_Callback(hObject, eventdata, handles)

[namafile,direktori]=uigetfile({'*.xls;*.xls','file excel(*.xls,*.xls)';'*.*','semua file(*.*)'},'buka file excell');

alamatfile=fullfile(direktori,namafile);

set(handles.edit1,'String',alamatfile);

[a,b,c]=xlsread(alamatfile);

% 'NO' 'NAMA' 'USIA' 'BERAT' 'TINGGI'

% [ 1] 'ADAM' [ 12] [ 30] [ 150]

% [ 2] 'SUSI' [ 15] [ 35] [ 155]

% [ 3] 'DEDI' [ 17] [ 40] [ 145]

% [ 4] 'DONI' [ 15] [ 38] [ 156]

bar=size(c,1);

col=size(c,2);

judul=c(1,2:col);

data=c(2:bar,2:col);

nom=linspace(1,bar-1,bar-1);

set(handles.myTable2lp2mAray,'data',data,'ColumnName',judul,'RowName',nom);

set(handles.myTable2lp2mAray,'Userdata',data);

myicon(:,:,1) = [0 1; 0 1];

myicon(:,:,2) = [.8 1; 0 .3];

myicon(:,:,3) = [.3 0; .9 .5];

h=msgbox('Sukses import','Success','custom',myicon);