setInputEncoding($encoding); } return $reader->load($file); } /** * Identify file format * * @param string $ext * @return string */ protected static function getFormatByExtension($ext) { $formart = ''; switch ($ext) { /* |-------------------------------------------------------------------------- | Excel 2007 |-------------------------------------------------------------------------- */ case 'xlsx': case 'xlsm': case 'xltx': case 'xltm': $formart = 'Xlsx'; break; /* |-------------------------------------------------------------------------- | Excel5 |-------------------------------------------------------------------------- */ case 'xls': case 'xlt': $formart = 'Xls'; break; /* |-------------------------------------------------------------------------- | CSV |-------------------------------------------------------------------------- */ case 'csv': case 'txt': $formart = 'Csv'; break; } return $formart; } }