$spreadsheet = $reader->load($filePath);
//读取sheet1
$worksheet= $spreadsheet->getActiveSheet(0);
//获取总行数
$highestRow=$worksheet->getHighestRow();
//获取总列数
$highestColumn=$worksheet->getHighestColumn();
//循环获取表中的数据,$currentRow表示当前行,从哪行开始读取数据,索引值从1开始
$data=[];
for ($row = $rowstart; $row <= $highestRow; ++$row) {
for ($col = $colstart; $col <= $highestColumn; ++$col) {
//数据坐标
$address=$col.$row;
$value[$row][$col] = $worksheet->getCell($address)->getCalculatedValue();
if($row > $rowstart){
$data = $value[$row][$col].$value[$row-$rowstart][$col];
}
}
}
return $value;
如何当整行值为空时,就不写入数组了,请大神指导,非常感谢!
最佳答案