GUI :Guardar cuadro de texto y exportar a excel
Publicado por Angela (4 intervenciones) el 29/01/2014 11:36:08
Hola a todos y muchas gracias por adelantado.
Estoy haciendo un pequeño programa para hacer un test con GUI y estoy atascada en lo siguiente. En una pantalla tengo dos cuadros de texto, uno lo quiero usar para introducir el nombre y otro para la edad. Lo que quiero es que cuando la persona que está introduciendo su nombre y su edad pulse en "Siguiente" (que pasa a la siguiente pantalla), el programa guarde los valores introducidos en el cuadro de texto y los exporte a un archivo excel.
Si alguien me pudiera ayudar se lo agradezco en el alma!
Os pego el código que tengo:
function varargout = D9(varargin)
% D9 MATLAB code for D9.fig
% D9, by itself, creates a new D9 or raises the existing
% singleton*.
%
% H = D9 returns the handle to a new D9 or the handle to
% the existing singleton*.
%
% D9('CALLBACK',hObject,eventData,handles,...) calls the local
% function named CALLBACK in D9.M with the given input arguments.
%
% D9('Property','Value',...) creates a new D9 or raises the
% existing singleton*. Starting from the left, property value pairs are
% applied to the GUI before D9_OpeningFcn gets called. An
% unrecognized property name or invalid value makes property application
% stop. All inputs are passed to D9_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 D9
% Last Modified by GUIDE v2.5 22-Jan-2014 10:47:00
% Begin initialization code - DO NOT EDIT
gui_Singleton = 1;
gui_State = struct('gui_Name', mfilename, ...
'gui_Singleton', gui_Singleton, ...
'gui_OpeningFcn', @D9_OpeningFcn, ...
'gui_OutputFcn', @D9_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 D9 is made visible.
function D9_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 D9 (see VARARGIN)
% Choose default command line output for D9
handles.output = hObject;
% Update handles structure
guidata(hObject, handles);
% UIWAIT makes D9 wait for user response (see UIRESUME)
% uiwait(handles.figure1);
% --- Outputs from this function are returned to the command line.
function varargout = D9_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 button press in Siguiente.
function Siguiente_Callback(hObject, eventdata, handles)
D11;
% hObject handle to Siguiente (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
function Nombre_Callback(hObject, eventdata, handles)
% hObject handle to Nombre (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 Nombre as text
% str2double(get(hObject,'String')) returns contents of Nombre as a double
Nombre_texto= get(hObject, 'String');
% --- Executes during object creation, after setting all properties.
function Nombre_CreateFcn(hObject, eventdata, handles)
% hObject handle to Nombre (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
function Edad_Callback(hObject, eventdata, handles)
% hObject handle to Edad (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 Edad as text
% str2double(get(hObject,'String')) returns contents of Edad as a double
%Edad = get(handles.Edad, 'String');
Edad_texto= get(hObject, 'String');
% --- Executes during object creation, after setting all properties.
function Edad_CreateFcn(hObject, eventdata, handles)
% hObject handle to Edad (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
Estoy haciendo un pequeño programa para hacer un test con GUI y estoy atascada en lo siguiente. En una pantalla tengo dos cuadros de texto, uno lo quiero usar para introducir el nombre y otro para la edad. Lo que quiero es que cuando la persona que está introduciendo su nombre y su edad pulse en "Siguiente" (que pasa a la siguiente pantalla), el programa guarde los valores introducidos en el cuadro de texto y los exporte a un archivo excel.
Si alguien me pudiera ayudar se lo agradezco en el alma!
Os pego el código que tengo:
function varargout = D9(varargin)
% D9 MATLAB code for D9.fig
% D9, by itself, creates a new D9 or raises the existing
% singleton*.
%
% H = D9 returns the handle to a new D9 or the handle to
% the existing singleton*.
%
% D9('CALLBACK',hObject,eventData,handles,...) calls the local
% function named CALLBACK in D9.M with the given input arguments.
%
% D9('Property','Value',...) creates a new D9 or raises the
% existing singleton*. Starting from the left, property value pairs are
% applied to the GUI before D9_OpeningFcn gets called. An
% unrecognized property name or invalid value makes property application
% stop. All inputs are passed to D9_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 D9
% Last Modified by GUIDE v2.5 22-Jan-2014 10:47:00
% Begin initialization code - DO NOT EDIT
gui_Singleton = 1;
gui_State = struct('gui_Name', mfilename, ...
'gui_Singleton', gui_Singleton, ...
'gui_OpeningFcn', @D9_OpeningFcn, ...
'gui_OutputFcn', @D9_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 D9 is made visible.
function D9_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 D9 (see VARARGIN)
% Choose default command line output for D9
handles.output = hObject;
% Update handles structure
guidata(hObject, handles);
% UIWAIT makes D9 wait for user response (see UIRESUME)
% uiwait(handles.figure1);
% --- Outputs from this function are returned to the command line.
function varargout = D9_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 button press in Siguiente.
function Siguiente_Callback(hObject, eventdata, handles)
D11;
% hObject handle to Siguiente (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
function Nombre_Callback(hObject, eventdata, handles)
% hObject handle to Nombre (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 Nombre as text
% str2double(get(hObject,'String')) returns contents of Nombre as a double
Nombre_texto= get(hObject, 'String');
% --- Executes during object creation, after setting all properties.
function Nombre_CreateFcn(hObject, eventdata, handles)
% hObject handle to Nombre (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
function Edad_Callback(hObject, eventdata, handles)
% hObject handle to Edad (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 Edad as text
% str2double(get(hObject,'String')) returns contents of Edad as a double
%Edad = get(handles.Edad, 'String');
Edad_texto= get(hObject, 'String');
% --- Executes during object creation, after setting all properties.
function Edad_CreateFcn(hObject, eventdata, handles)
% hObject handle to Edad (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
Valora esta pregunta


0