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

% Last Modified by GUIDE v2.5 25-Dec-2010 23:10:04

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

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

% Update handles structure
guidata(hObject, handles);

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


% --- Outputs from this function are returned to the command line.
function varargout = testImportExcel_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)



% --- 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','green');
    hold on 
end



% --- Executes on button press in pushbutton1.
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( ...
{  '*.xls','Excel 2007 (*.xls)'; ...
   '*.xlsx','Excel 2010 (*.xlsx)'; ...
   '*.*',  'All Files (*.*)'}, ...
   'Pick a file', ...
   'MultiSelect', 'on');

if ~isequal(filename,0)
    if iscell(filename)
        for n=1:length(filename)
            h = waitbar(n/length(filename),'Excel files werden geladen!');
            [Data.(sprintf('Num%.0f',n)) Data.(sprintf('Text%.0f',n))] = xlsread(fullfile(pathname,filename{n}));
            close(h)
        end
    else
        [Data.Num1 Data.Text1] = xlsread(fullfile(pathname,filename));
    end
    set(handles.listbox1,'String',filename)
    handles.Data = Data;
    guidata(handles.figure1,handles);
end


% --- Executes on mouse press over axes background.
function axes1_ButtonDownFcn(hObject, eventdata, handles)
% hObject    handle to axes1 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)


% --- Executes during object deletion, before destroying properties.
function axes1_DeleteFcn(hObject, eventdata, handles)
% hObject    handle to axes1 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)



% --- Executes on selection change in listbox2.
function listbox2_Callback(hObject, eventdata, handles)
% hObject    handle to listbox2 (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 listbox2 contents as cell array
%        contents{get(hObject,'Value')} returns selected item from listbox2



% --- 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','green');
    hold on 
end



% --- Executes on button press in pushbutton1.
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( ...
{  '*.xls','Excel 2007 (*.xls)'; ...
   '*.xlsx','Excel 2010 (*.xlsx)'; ...
   '*.*',  'All Files (*.*)'}, ...
   'Pick a file', ...
   'MultiSelect', 'on');

if ~isequal(filename,0)
    if iscell(filename)
        for n=1:length(filename)
            h = waitbar(n/length(filename),'Excel files werden geladen!');
            [Data.(sprintf('Num%.0f',n)) Data.(sprintf('Text%.0f',n))] = xlsread(fullfile(pathname,filename{n}));
            close(h)
        end
    else
        [Data.Num1 Data.Text1] = xlsread(fullfile(pathname,filename));
    end
    set(handles.listbox1,'String',filename)
    handles.Data = Data;
    guidata(handles.figure1,handles);
end


% --- Executes on mouse press over axes background.
function axes1_ButtonDownFcn(hObject, eventdata, handles)
% hObject    handle to axes1 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)


% --- Executes during object deletion, before destroying properties.
function axes1_DeleteFcn(hObject, eventdata, handles)
% hObject    handle to axes1 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)



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 pushbutton5.
function pushbutton5_Callback(hObject, eventdata, handles)
% hObject    handle to pushbutton5 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)
try
    
    set(hObject,'Enable','off')
    pause(0.001)
    val = get(hObject,'Value');
    data = str2double(handles.Data.(sprintf('Text%.0f',val))(:,2));
    dates = datenum(handles.Data.(sprintf('Text%.0f',val))(:,1),'dd.mm.yyyy HH:MM:SS');
    plot(dates,data(:,1))
    datetick
    xlabel('Time');
    ylabel('Solar activity')
    set(hObject,'Enable','on')
    hold on
     h = zoom;
set(h,'Motion','horizontal','Enable','on');
set(gcf,'Color',[1,0.4,0.6])
catch %#ok
    set(hObject,'Enable','on')
    hold on
end


% --- Executes on button press in pushbutton6.
function pushbutton6_Callback(hObject, eventdata, handles)
% hObject    handle to pushbutton6 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)
try
    
    set(hObject,'Enable','off')
    pause(0.001)
    val = get(hObject,'Value');
    data = str2double(handles.Data.(sprintf('Text%.0f',val))(:,3));
    dates = datenum(handles.Data.(sprintf('Text%.0f',val))(:,1),'dd.mm.yyyy HH:MM:SS');
    plot(dates,data(:,1))
    datetick
    xlabel('Time');
    ylabel('Solar activity')
    set(hObject,'Enable','on')
    hold on
     h = zoom;
set(h,'Motion','horizontal','Enable','on');
set(gcf,'Color',[1,0.4,0.6])
catch %#ok
    set(hObject,'Enable','on')
    hold on
end