php 导入excel数据

 

composer require phpoffice/phpspreadsheet

use PhpOffice\PhpSpreadsheet\Reader\Xlsx;     

        $reader = new Xlsx();
        $spreadsheet = $reader->load($fileName);
        $worksheet = $sheet = $spreadsheet->getActiveSheet();
        $data = [];

        $highestRow = $worksheet->getHighestRow(); // 总行数
        //$highestColumn = $worksheet->getHighestColumn(); // 总列数

      $data = [];
      for ($row = 2; $row <= $highestRow; ++$row) {
            $rowData = [];
            $rowData[] = $worksheet->getCellByColumnAndRow(1, $row)->getValue();
            $rowData[] = $worksheet->getCellByColumnAndRow(2, $row)->getValue();
            $rowData[] = $worksheet->getCellByColumnAndRow(3, $row)->getValue();
            $rowData[] = $worksheet->getCellByColumnAndRow(4, $row)->getValue();
            $rowData[] = $worksheet->getCellByColumnAndRow(5, $row)->getValue();

            $data[] = $rowData;
        }        

        var_dump($data);