$files = array(); foreach ($tFiles as $file) { $files[$file] = basename($file); } $excelFile = isset($_POST['file']) ? $_POST['file'] : (isset($_SESSION['file']) ? $_SESSION['file'] : $tFiles[0]); $_SESSION['file'] = $excelFile; if (isset($_POST['file'])) { $_SESSION['options'] = $sessionOptions = array(); } print formElement(formLabel('file', 'Load file'), formSelect('file', $excelFile, $files)); print formElement('', formSubmit('set-file', 'Change file')); print formEnd(); ######################################################################################################################## ## Options form ######################################################################################################## ######################################################################################################################## $reader = QExcel::createReaderForFile($excelFile); $options = $reader->getDefaultOptions(); $loadSheet = 0; echo '<h2>Options</h2>'; print formStart(); foreach ($options as $option => $defaultValue) { switch ($option) { case 'encoding': // Some random encodings found on iconvlib $tEncodings = array('ASCII', 'ISO-8859-1', 'ISO-8859-2', 'ISO-8859-3', 'ISO-8859-4', 'ISO-8859-5', 'ISO-8859-7', 'ISO-8859-9', 'ISO-8859-10', 'ISO-8859-13', 'ISO-8859-14', 'ISO-8859-15', 'ISO-8859-16', 'KOI8-R', 'KOI8-U', 'KOI8-RU', 'CP1250', 'CP1251', 'CP1252', 'CP1253', 'CP1254', 'CP1257', 'CP850', 'CP866', 'CP1131', 'MacRoman', 'MacCentralEurope', 'MacIceland', 'MacCroatian', 'MacRomania', 'MacCyrillic', 'MacUkraine', 'MacGreek', 'MacTurkish', 'Macintosh', 'UTF-8', 'UTF-16LE', 'UTF-16BE', 'UTF-32LE'); // We need a key value array for our formSelect 'view helper' $encodings = array(); foreach ($tEncodings as $encoding) { $encodings[$encoding] = $encoding; } // print the option