PhpSpreadsheet读取上传excel

if (!move_uploaded_file($_FILES["file"]["tmp_name"], $filename)) {
  return ['result' => false, 'msg' => '无法移动文件'];
}

$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load($filename);
$worksheet = $spreadsheet->getActiveSheet();
$highestRow = $worksheet->getHighestRow();

for ($rowIndex = 0; $rowIndex <= $highestRow; $rowIndex++) {

  if ($worksheet->getCell("A" . ($rowIndex + 1))->getValue() != null || $worksheet->getCell("A" . ($rowIndex + 1))->getValue()) {

    $rows[$rowIndex]['id'] = $worksheet->getCell("A" . ($rowIndex + 1))->getValue();
    $rows[$rowIndex] ['level'] = $worksheet->getCell("B" . ($rowIndex + 1))->getValue();
    $rows[$rowIndex] ['price'] = $worksheet->getCell("C" . ($rowIndex + 1))->getValue();
    $rows[$rowIndex] ['amount'] = $worksheet->getCell("D" . ($rowIndex + 1))->getValue();
  }
}

zhuan:https://blog.csdn.net/canlynetsky/article/details/101344773?utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7EBlogCommendFromMachineLearnPai2%7Edefault-4.control&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7EBlogCommendFromMachineLearnPai2%7Edefault-4.control