sql server - Is it possible to upload excel (.xls) file to mssql in cake php? -

sql server - Is it possible to upload excel (.xls) file to mssql in cake php? -

i know of research recommend upload in csv format more easier. due user requirement need upload in excel xls format database, possible in cake php? or utilize other method convert xls file csv file upload? give thanks you!

i have seek out...and shows undefined variable:ext , undefined index:upload

$destination = realpath('../../app/webroot/uploads/excel/' . '/'); if(isset($_files['upload']['xls_file'])) $ext = substr($_files['upload']['xls_file'], strrpos($_files['upload']['xls_file'], '.') + 1); $path = $destination.'excel'.$ext; move_uploaded_file($_files['upload']['tmp_name'], $path); $data = new spreadsheet_excel_reader($path, true); $temp = $data->dumptoarray(); if($temp) { foreach ($temp $key=>$val) { $val['0']; } } }

php sql-server excel cakephp csv