Доброго всем дням. <?php require_once( DIR .'/assets/SimpleExcel/SimpleExcel.php'); require_once DIR . '/assets/Crest/crest.php'; require_once

Question

Доброго всем дням. <?php require_once( DIR .'/assets/SimpleExcel/SimpleExcel.php'); require_once DIR . '/assets/Crest/crest.php'; require_once

DIR . '/assets/Crest/settings.php';
use SimpleExcel\SimpleExcel;
use SimpleExcel\Parser;
use SimpleExcel\Parser\IParser;
use SimpleExcel\Parser\BaseParser;
use SimpleExcel\Parser\XLSXParser;

//print_r($_REQUEST);
dumpLog($_REQUEST);
$dealid =$_REQUEST['dealID'];
$arParamsDisk = [
'id' => $_REQUEST['diskId'],
// 'auth' => $_REQUEST['auth']['access_token']
];
dumpLog($arParamsDisk['id']);

$RequestFile = CRest::call('disk.file.get',$arParamsDisk);
dumpLog($RequestFile['result']['DOWNLOAD_URL']);
$inputFileName = trim(file_get_contents($RequestFile['result']['DOWNLOAD_URL']));
//$file_encodings = ['cp1251', 'UTF-8'];
$savePath = DIR . '/tmpFiles/file.xlsx'; // путь для сохранения файла на сервере
file_put_contents($savePath, $inputFileName);

//$encoded_cont = mb_convert_encoding($inputFileName, 'UTF-8', mb_detect_encoding($inputFileName, $file_encodings));
dumpLog($savePath);
$excel = new SimpleExcel('xlsx');
//dumpLog($excel->parser);
//$parser = $excel->constructParser('xlsx');
//dumpLog($parser);
$excel-> parser->loadFile($savePath);
$worksheet = $excel->parser->getWorksheet();
$Rows = $worksheet->getRows();
foreach ($Rows as $row) {
dumpLog($row);
}
$res = unlink($savePath);
dumpLog($res);
dumpLog("Конец");

function dumpLog($data){
echo '<PRE><BR>'.
var_dump($data).
'<BR></PRE>';
}