描述：下面import()方法是將上傳的excel表轉(zhuǎn)為一個二維數(shù)組，必須傳入兩個參數(shù)，參數(shù)1file_tmp為臨時目錄文件，我的excel表格第一行是描述，直接在方法中過濾掉。

1.要使用方法，首先引入類庫，我用的是phpoffice

2.composer引入方法：項目中執(zhí)行 composer require phpoffice/phpexcel

public function import($file,$file_tmp)
    {
        //獲取文件后綴
        $extension = strtolower( pathinfo($file, PATHINFO_EXTENSION) );
        //定義可上次的文件后綴
        $extensions = ['xlsx','xls'];
        //判斷文件后綴是否合法
        if(!in_array($extension,$extensions)){
            return '上傳文件不合法';
        }
        $spreadsheet = IOFactory::load($file_tmp);
        $sheet = $spreadsheet->getActiveSheet();
    //        $data = $sheet->getCellCollection ();
    //        $title = $sheet->getTitle();
    //        $data = $sheet->getColumnDimensions();
        $highestRow = $sheet->getHighestRow(); // 總行數(shù)
        $highestColumn = $sheet->getHighestColumn(); // 總列數(shù)
        $highestColumnIndex = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::columnIndexFromString($highestColumn);

        $lines = $highestRow - 1;
        if ($lines <= 0) {
            return '表格為空';
        }

        for ($row = 2; $row <= $highestRow; ++$row) {
            $rowData = [];
            for ($column = 1; $column <= $highestColumnIndex; $column++) {
                $model_no = $sheet->getCellByColumnAndRow($column, $row)->getValue();
                $rowData[] = $model_no;
            }
            $rowData1[] = $rowData;
        }

        return $rowData1;
    }