protected function uploadxls($res){
$root=$_SERVER['DOCUMENT_ROOT'];
$filePath=$root.$res['folder'].$res['filesavename'];
//y读取文件数据
if($res['filetype']=='xls'){
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xls();
$reader->setReadDataOnly(TRUE);
}else if($res['filetype']=='xlsx'){
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
$reader->setReadDataOnly(TRUE);
}
//读取上传明细文件
$spreadsheet = $reader->load($filePath);
//读取sheet1
$worksheet= $spreadsheet->getActiveSheet(0);
//获取总行数
$highestRow=$worksheet->getHighestRow();
//获取总列数
$highestColumn=$worksheet->getHighestColumn();
//循环获取表中的数据，$currentRow表示当前行，从哪行开始读取数据，索引值从1开始
$data=[];
for ($row = 2; $row <= $highestRow; ++$row) {
for ($col = 1; $col <=$highestColumn; ++$col) {
//数据坐标
$address=$col.$row;
$value[$row][$col] = $worksheet->getCell($address)->getValue();
if($row > 2){
$data = $value[$row][$col].$value[$row-2][$col];
}
}
//判断当前为空行 就结束
if(empty($data)){
unset($value[$row]);
break;
}
}
var_dump($data);
}
上面的过程，表格已正常加载，行数、列数打印数据正常，但打印循环表格数据为空，麻烦各位指导哈哪里错误了，非常感谢！