public function execute()
{
$anOtherPHPExcelObject = PHPExcel_IOFactory::load($this->inputFileName);
//var_dump($anOtherPHPExcelObject->setActiveSheetIndex()->getHighestRowAndColumn()["row"]);
$rowLength = $anOtherPHPExcelObject->setActiveSheetIndex()->getHighestRowAndColumn()["row"];
$objReader = PHPExcel_IOFactory::createReader($this->inputFileType);
$filterSubset = new MyReadFilter(1, $rowLength, range(TYPE_ENSEIGNANT, TP));
$objReader->setReadFilter($filterSubset);
$onePHPExcelObject = $objReader->load($this->inputFileName);
$MatiereTemp = new Matiere();
$ClasseTemp = "";
$EnseignantTemp = new Enseignant();
$sheet = $onePHPExcelObject->getSheet(0);
// On récupère le premier feuillet
$TeacherInfo = "";
foreach ($sheet->getRowIterator() as $row) {
foreach ($row->getCellIterator() as $cell) {
$column = $cell->getColumn();
$valeur = $cell->getValue();
//print_r($cell->getCoordinate());
//print_r($cell->getColumn());
if ($column == TYPE_ENSEIGNANT) {
//$EnseignantTemp->Type = $valeur;
$TeacherInfo = $TeacherInfo . "|" . $valeur;
}
if ($column == NOM) {
$TeacherInfo = $TeacherInfo . "|" . $valeur;
//$EnseignantTemp->Nom = $valeur;
//echo $valeur." ";
}
if ($column == PRENOM) {
$TeacherInfo = $TeacherInfo . "|" . $valeur;
//$EnseignantTemp->Prenom = $valeur;
//echo $valeur." ";
}
if ($column == TITRE) {
$TeacherInfo = $TeacherInfo . "|" . $valeur;
//$EnseignantTemp->Grade = $valeur;
//echo $valeur." ";
}
if ($column == TYPE_AFFECTATION) {
$TeacherInfo = $TeacherInfo . "|" . $valeur;
//$EnseignantTemp->Affectation = $valeur;
}
if ($column == CLASSE) {
$ClasseTemp = $cell->getValue();
}
if ($column == MATIERE) {
$matiere = new Matiere($cell->getValue());
$enseignant = new Enseignant($TeacherInfo);
$matiere->Classe = $ClasseTemp;
$matiere->addEnseignant($enseignant);
$MatiereTemp = $matiere;
array_push($this->MatiereList, $matiere);
//print_r($cell->getValue());
$TeacherInfo = $TeacherInfo . "\n";
//echo $TeacherInfo;
}
if ($column == SEMESTRE1) {
end($this->MatiereList)->Semestre1 = $valeur;
}
if ($column == SEMESTRE2) {
end($this->MatiereList)->Semestre2 = $valeur;
}
if ($column == CM) {
end($this->MatiereList)->CM = $valeur;
end($this->MatiereList)->addFirstHoraire("CM", $valeur);
}
if ($column == TD) {
end($this->MatiereList)->TD = $valeur;
end($this->MatiereList)->addFirstHoraire("TD", $valeur);
}
if ($column == TP) {
end($this->MatiereList)->TP = $valeur;
end($this->MatiereList)->addFirstHoraire("TP", $valeur);
}
}
$TeacherInfo = "";
//Initialize Teacher information
}
}
