临近考试的课设,做的很匆忙。
首先是GUI的相关代码:
function varargout = GUI01(varargin)
% GUI01 MATLAB code for GUI01.fig
% GUI01, by itself, creates a new GUI01 or raises the existing
% singleton*.
%
% H = GUI01 returns the handle to a new GUI01 or the handle to
% the existing singleton*.
%
% GUI01('CALLBACK',hObject,eventData,handles,...) calls the local
% function named CALLBACK in GUI01.M with the given input arguments.
%
% GUI01('Property','Value',...) creates a new GUI01 or raises the
% existing singleton*. Starting from the left, property value pairs are
% applied to the GUI before GUI01_OpeningFcn gets called. An
% unrecognized property name or invalid value makes property application
% stop. All inputs are passed to GUI01_OpeningFcn via varargin.
%
% *See GUI Options on GUIDE's Tools menu. Choose "GUI allows only one
% instance to run (singleton)".
%
% See also: GUIDE, GUIDATA, GUIHANDLES
% Edit the above text to modify the response to help GUI01
% Last Modified by GUIDE v2.5 19-Dec-2019 10:04:10
% Begin initialization code - DO NOT EDIT
gui_Singleton = 1;
gui_State = struct('gui_Name', mfilename, ...
'gui_Singleton', gui_Singleton, ...
'gui_OpeningFcn', @GUI01_OpeningFcn, ...
'gui_OutputFcn', @GUI01_OutputFcn, ...
'gui_LayoutFcn', [] , ...
'gui_Callback', []);
if nargin && ischar(varargin{1})
gui_State.gui_Callback = str2func(varargin{1});
end
if nargout
[varargout{1:nargout}] = gui_mainfcn(gui_State, varargin{:});
else
gui_mainfcn(gui_State, varargin{:});
end
% End initialization code - DO NOT EDIT
% --- Executes just before GUI01 is made visible.
function GUI01_OpeningFcn(hObject, eventdata, handles, varargin)
% This function has no output args, see OutputFcn.
% hObject handle to figure
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
% varargin command line arguments to GUI01 (see VARARGIN)
% Choose default command line output for GUI01
handles.output = hObject;
% fin=fopen('chengji.txt','r')
% str=fgetl(fin);
% [str1 str2 str3 str4]=strread(str,'%s %s %s %s','delimiter',' ')
% xingming(1)=str1;
%
% counter=2;
% while feof(fin)==0
% str=fgetl(fin);
% [name yuwen shuxue yingyu]=strread(str,'%s %d %d %d','delimiter',' ')
% xingming(counter)=name;
% chengji(counter-1,:)=[yuwen shuxue yingyu];
% counter=counter+1;
% end;
%
% set(handles.listbox1,'string',xingming)
% handles.chengji=chengji;
% fclose(fin);
% Update handles structure
guidata(hObject, handles);
% UIWAIT makes GUI01 wait for user response (see UIRESUME)
% uiwait(handles.figure1);
% --- Outputs from this function are returned to the command line.
function varargout = GUI01_OutputFcn(hObject, eventdata, handles)
% varargout cell array for returning output args (see VARARGOUT);
% hObject handle to figure
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
% Get default command line output from handles structure
varargout{1} = handles.output;
% --- Executes on selection change in listbox1.
function listbox1_Callback(hObject, eventdata, handles)
% hObject handle to listbox1 (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 listbox1 contents as cell array
% contents{get(hObject,'Value')} returns selected item from listbox1
value=get(hObject,'value')-1;
set(handles.edit1,'string',num2str(handles.chengji(value,:)));
% --- Executes during object creation, after setting all properties.
function listbox1_CreateFcn(hObject, eventdata, handles)
% hObject handle to listbox1 (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles empty - handles not created until after all CreateFcns called
% Hint: listbox controls usually have a white background on Windows.
% See ISPC and COMPUTER.
if ispc && isequal(get(hObject,'BackgroundColor'), get(0,'defaultUicontrolBackgroundColor'))
set(hObject,'BackgroundColor','white');
end
function edit1_Callback(hObject, eventdata, handles)
% hObject handle to edit1 (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
% Hints: get(hObject,'String') returns contents of edit1 as text
% str2double(get(hObject,'String')) returns contents of edit1 as a double
% --- Executes during object creation, after setting all properties.
function edit1_CreateFcn(hObject, eventdata, handles)
% hObject handle to edit1 (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles empty - handles not created until after all CreateFcns called
% Hint: edit controls usually have a white background on Windows.
% See ISPC and COMPUTER.
if ispc && isequal(get(hObject,'BackgroundColor'), get(0,'defaultUicontrolBackgroundColor'))
set(hObject,'BackgroundColor','white');
end
% --- Executes on button press in pushbutton2.
function pushbutton2_Callback(hObject, eventdata, handles)
% hObject handle to pushbutton2 (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('*.xls','Choose a File');
str=[PathName FileName];
set(handles.edit2,'string',str);
[chengji xingming]=xlsread(str);
set(handles.listbox1,'string',xingming(:,1));
handles.chengji=chengji;
guidata(hObject,handles)
msgbox('读取完成');
function edit2_Callback(hObject, eventdata, handles)
% hObject handle to edit2 (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
% Hints: get(hObject,'String') returns contents of edit2 as text
% str2double(get(hObject,'String')) returns contents of edit2 as a double
% --- Executes during object creation, after setting all properties.
function edit2_CreateFcn(hObject, eventdata, handles)
% hObject handle to edit2 (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles empty - handles not created until after all CreateFcns called
% Hint: edit controls usually have a white background on Windows.
% See ISPC and COMPUTER.
if ispc && isequal(get(hObject,'BackgroundColor'), get(0,'defaultUicontrolBackgroundColor'))
set(hObject,'BackgroundColor','white');
end
% --- Executes on button press in pushbutton3.
function pushbutton3_Callback(hObject, eventdata, handles)
% hObject handle to pushbutton3 (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
creat_word
msgbox('已导出至当前路径:试卷分析报告.doc');
% --- Executes on button press in Quit.
function Quit_Callback(hObject, eventdata, handles)
% hObject handle to Quit (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
close(gcf)
涉及到了成绩查询系统及考试分析系统的界面
界面效果图如下:
接着是生成word文档版本的报告:
(代码太多省略掉一部分了)
报告格式:
列 :9
行:15
设置对齐方式,行宽,列高,合并单元格等一系列内容…
通过 DTI.Cell(n,n).Range.Text = ''xx; 来书写单元格的内容
(并没有用循环写内容)