打开excel文件

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)
[Filename Pathname] = uigetfile({'*.xlsx'}, 'Choose a file');
str = [Pathname Filename];
%将读取的文件地址显示在edit2中
set(handles.edit2, 'string', str);
%读取文件
[chengji xingming] = xlsread(str);
%每行都要，但只要第一列
set(handles.listbox1, 'string', xingming(:, 1));
%设置全局变量
handles.chengji = chengji;
%更新gui
guidata(hObject, handles);

运行结果如下：