foreach ($files as $key => $filename) {
printf("%2d. {$filename}\n", $key + 1, $filename);
}
$choice = readline("Sélection du fichier à importer: ");
if (!array_key_exists(--$choice, $files)) {
exit_error("Fichier non trouvé");
}
$filename = $files[$choice];
echo "\n";
}
echo "Importation de '{$filename}'\n";
// Initialize Excel Reader
$xlReader = new PHPExcel_Reader_Excel2007();
$xlReader->setLoadSheetsOnly(IMPORT_COTI_SHEET_NAME)->setReadDataOnly(true);
// Retrieve header row
$xlReader->setReadFilter(new ReadFilterFirstRow());
$xl = $xlReader->load($filename);
$xlWS = $xl->getSheet(0);
$headers = array();
foreach ($xlWS->getRowIterator(1)->current()->getCellIterator() as $cell) {
$headers[$cell->getColumn()] = $cell->getValue();
}
// Read the rest of the data file
try {
$xlReader->setReadFilter(new ReadFilterEmailCoti($headers));
} catch (ColumnNotDefinedException $e) {
print "ERREUR: " . $e->getMessage() . "\n";
die(1);
}
$xl = $xlReader->load($filename);
$xlWS = $xl->getSheet(0);
