function varargout = Versuch1umhanldeszupruefen(varargin)
% VERSUCH1UMHANLDESZUPRUEFEN MATLAB code for Versuch1umhanldeszupruefen.fig
%      VERSUCH1UMHANLDESZUPRUEFEN, by itself, creates a new VERSUCH1UMHANLDESZUPRUEFEN or raises the existing
%      singleton*.
%
%      H = VERSUCH1UMHANLDESZUPRUEFEN returns the handle to a new VERSUCH1UMHANLDESZUPRUEFEN or the handle to
%      the existing singleton*.
%
%      VERSUCH1UMHANLDESZUPRUEFEN('CALLBACK',hObject,eventData,handles,...) calls the local
%      function named CALLBACK in VERSUCH1UMHANLDESZUPRUEFEN.M with the given input arguments.
%
%      VERSUCH1UMHANLDESZUPRUEFEN('Property','Value',...) creates a new VERSUCH1UMHANLDESZUPRUEFEN or raises the
%      existing singleton*.  Starting from the left, property value pairs are
%      applied to the GUI before Versuch1umhanldeszupruefen_OpeningFcn gets called.  An
%      unrecognized property name or invalid value makes property application
%      stop.  All inputs are passed to Versuch1umhanldeszupruefen_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 Versuch1umhanldeszupruefen

% Last Modified by GUIDE v2.5 19-Jul-2013 14:16:43

% Begin initialization code - DO NOT EDIT
gui_Singleton = 1;
gui_State = struct('gui_Name',       mfilename, ...
                   'gui_Singleton',  gui_Singleton, ...
                   'gui_OpeningFcn', @Versuch1umhanldeszupruefen_OpeningFcn, ...
                   'gui_OutputFcn',  @Versuch1umhanldeszupruefen_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 Versuch1umhanldeszupruefen is made visible.
function Versuch1umhanldeszupruefen_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 Versuch1umhanldeszupruefen (see VARARGIN)

% Choose default command line output for Versuch1umhanldeszupruefen
handles.output = hObject;

% Update handles structure
guidata(hObject, handles);

% UIWAIT makes Versuch1umhanldeszupruefen wait for user response (see UIRESUME)
% uiwait(handles.figure1);


% --- Outputs from this function are returned to the command line.
function varargout = Versuch1umhanldeszupruefen_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 popupmenu1.
function popupmenu1_Callback(hObject, eventdata, handles)
% hObject    handle to popupmenu1 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)
handles.output = hObject;

folder = uigetdir();
set(handles.popupmenu1, 'string' , folder)
handles.folder = folder;
a = dir('*.xls');
aNames = {a.name};
set(handles.popupmenu2, 'string' , aNames)
guidata(handles.Versuch1umhandleszupruefen , handles)
guidata(hObject, handles);
% Hints: contents = cellstr(get(hObject,'String')) returns popupmenu1 contents as cell array
%        contents{get(hObject,'Value')} returns selected item from popupmenu1


% --- Executes during object creation, after setting all properties.
function popupmenu1_CreateFcn(hObject, eventdata, handles)
% hObject    handle to popupmenu1 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    empty - handles not created until after all CreateFcns called

% Hint: popupmenu 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 selection change in popupmenu2.
function popupmenu2_Callback(hObject, eventdata, handles)
% hObject    handle to popupmenu2 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)
handles.output = hObject;

index_selected = get(hObject, 'Value' ) ;
list = get(hObject , 'string') ;
item_selected = list{index_selected};

cd(handles.folder);
[format, sheets] = xlsfinfo(item_selected);
Worksheets = sheets(1,:);
handles.Worksheets = Worksheets;
set(handles.popupmenu3, 'string' , Worksheets)
guidata(hObject, handles);

% Hints: contents = cellstr(get(hObject,'String')) returns popupmenu2 contents as cell array
%        contents{get(hObject,'Value')} returns selected item from popupmenu2


% --- Executes during object creation, after setting all properties.
function popupmenu2_CreateFcn(hObject, eventdata, handles)
% hObject    handle to popupmenu2 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    empty - handles not created until after all CreateFcns called

% Hint: popupmenu 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 selection change in popupmenu3.
function popupmenu3_Callback(hObject, eventdata, handles)
% hObject    handle to popupmenu3 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)
handles.output = hObject;
guidata(hObject, handles);

% Hints: contents = cellstr(get(hObject,'String')) returns popupmenu3 contents as cell array
%        contents{get(hObject,'Value')} returns selected item from popupmenu3


% --- Executes during object creation, after setting all properties.
function popupmenu3_CreateFcn(hObject, eventdata, handles)
% hObject    handle to popupmenu3 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    empty - handles not created until after all CreateFcns called

% Hint: popupmenu 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