- 积分
- 0
- 注册时间
- 2008-3-20
- 仿真币
-
- 最后登录
- 1970-1-1
|
楼主 |
发表于 2009-11-27 10:37:23
|
显示全部楼层
来自 河南郑州
本帖最后由 昨日的风 于 2009-11-27 10:39 编辑
function xinjian_Callback(hObject, eventdata, handles)
% hObject handle to xinjian (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
set(handles.ZJXH1,'string',num2str(0));
set(handles.H1min,'string',num2str(0));
set(handles.H1max,'string',num2str(0));
set(handles.step1,'string',num2str(0));
set(handles.p11,'string',num2str(0));
set(handles.p12,'string',num2str(0));
set(handles.L115,'string',num2str(0));
set(handles.L116,'string',num2str(0));
set(handles.f1,'string',num2str(0));
set(handles.L11,'string',num2str(0));
set(handles.L12,'string',num2str(0));
set(handles.L13,'string',num2str(0));
set(handles.L14,'string',num2str(0));
set(handles.L15,'string',num2str(0));
set(handles.L16,'string',num2str(0));
set(handles.L17,'string',num2str(0));
set(handles.L18,'string',num2str(0));
set(handles.L19,'string',num2str(0));
set(handles.L110,'string',num2str(0));
set(handles.L111,'string',num2str(0));
set(handles.L112,'string',num2str(0));
set(handles.L113,'string',num2str(0));
set(handles.L114,'string',num2str(0));
set(handles.b1,'string',num2str(0));
% --- Executes on button press in shurushuju.
function shurushuju_Callback(hObject, eventdata, handles)
% hObject handle to shurushuju (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
global ZJXH
ZJXH=get(handles.ZJXH1,'string');
[filename, pathname]= uigetfile('*.xls');
file=[pathname filename];
[ndata, headertext]=xlsread(file);
BB=headertext;
BB(2,1)
AA=ndata
AA=AA(1,:)
%AA =xlsread(sprintf('%s',ZJXH),'sheet1','B2:X5');
AA
set(handles.ZJXH1,'string',BB(2,1));
set(handles.H1min,'string',num2str(AA(1)));
set(handles.H1max,'string',num2str(AA(2)));
set(handles.step1,'string',num2str(AA(3)));
set(handles.p11,'string',num2str(AA(4)));
set(handles.p12,'string',num2str(AA(5)));
set(handles.L115,'string',num2str(AA(6)));
set(handles.L116,'string',num2str(AA(7)));
set(handles.f1,'string',num2str(AA(8)));
set(handles.L11,'string',num2str(AA(9)));
set(handles.L12,'string',num2str(AA(10)));
set(handles.L13,'string',num2str(AA(11)));
set(handles.L14,'string',num2str(AA(12)));
set(handles.L15,'string',num2str(AA(13)));
set(handles.L16,'string',num2str(AA(14)));
set(handles.L17,'string',num2str(AA(15)));
set(handles.L18,'string',num2str(AA(16)));
set(handles.L19,'string',num2str(AA(17)));
set(handles.L110,'string',num2str(AA(18)));
set(handles.L111,'string',num2str(AA(19)));
set(handles.L112,'string',num2str(AA(20)));
set(handles.L113,'string',num2str(AA(21)));
set(handles.L114,'string',num2str(AA(22)));
set(handles.b1,'string',num2str(AA(23)));
% --- Executes on button press in canshushuchu.
function canshushuchu_Callback(hObject, eventdata, handles)
% hObject handle to canshushuchu (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
global ZJXH
ZJXH=get(handles.ZJXH1,'string');
Hmin=str2num(get(handles.H1min,'string'));
Hmax=str2num(get(handles.H1max,'string'));
step=str2num(get(handles.step1,'string'));
p1=str2num(get(handles.p11,'string'));
p2=str2num(get(handles.p12,'string'));
L15=str2num(get(handles.L115,'string'));
L16=str2num(get(handles.L116,'string'));
f=str2num(get(handles.f1,'string'));
L1=str2num(get(handles.L11,'string'));
L2=str2num(get(handles.L12,'string'));
L3=str2num(get(handles.L13,'string'));
L4=str2num(get(handles.L14,'string'));
L5=str2num(get(handles.L15,'string'));
L6=str2num(get(handles.L16,'string'));
L7=str2num(get(handles.L17,'string'));
L8=str2num(get(handles.L18,'string'));
L9=str2num(get(handles.L19,'string'));
L10=str2num(get(handles.L110,'string'));
L11=str2num(get(handles.L111,'string'));
L12=str2num(get(handles.L112,'string'));
L13=str2num(get(handles.L113,'string'));
L14=str2num(get(handles.L114,'string'));
b=str2num(get(handles.b1,'string'));
bb={char(ZJXH),Hmin,Hmax,step,p1,p2,L15,L16,f,L1,L2,L3,L4,L5,L6,L7,L8,L9,L10,L11,L12,L13,L14,b};
table1={'支架型号','支架最小高度','支架最大高度','高度变化步长','前立柱合力','后立柱合力','顶梁宽度','底座宽度','摩擦系数','L1','L2','L3','L4','L5','L6','L7','L8','L9','L10','L11','L12','L13','L14','b'};
xlswrite(sprintf('%s',ZJXH{1}),table1,'sheet1','A1');
xlswrite(sprintf('%s',ZJXH{1}),bb,'sheet1','A2');
如何我使用的是上面的语句,可以使从excel表格中导入的数据(shurushuju_Callback语句中)的数修改后再导出(canshushuchu-callback中);但如果在初始定义在编辑框中数值(L1,L2等的初始值)就不可以导出,出现如下错误;
??? Cell contents reference from a non-cell array object.
Error in ==> JS_DBG>canshushuchu_Callback at 430
xlswrite(sprintf('%s',ZJXH{1}),table1,'sheet1','A1');
Error in ==> gui_mainfcn at 96
feval(varargin{:});
Error in ==> JS_DBG at 44
gui_mainfcn(gui_State, varargin{:});
??? Error while evaluating uicontrol Callback
12# messenger |
|