%% Import data from spreadsheet
% Script for importing data from the following spreadsheet:
%
%    Workbook: /Users/paulerlinger/Desktop/Flugplan.xlsx
%    Worksheet: Tabelle1
%
% Auto-generated by MATLAB on 12-Nov-2021 10:41:11

%% Set up the Import Options and import the data
opts = spreadsheetImportOptions("NumVariables", 3);

% Specify sheet and range
opts.Sheet = "Tabelle1";
opts.DataRange = "A2:C137";

% Specify column names and types
opts.VariableNames = ["Abflugzeit", "PAX", "To"];
opts.VariableTypes = ["datetime", "double", "string"];

% Specify variable properties
opts = setvaropts(opts, "To", "WhitespaceRule", "preserve");
opts = setvaropts(opts, "To", "EmptyFieldRule", "auto");
opts = setvaropts(opts, "Abflugzeit", "InputFormat", "");

% Import the data
Flugplan = readtable("/Users/paulerlinger/Desktop/Flugplan.xlsx", opts, "UseExcel", false);


%% Clear temporary variables
clear opts