php spreadsheet导入

    /** 
     * 导入  
     */
    public function import()
    {
        //composer安装
        //composer require phpoffice/phpspreadsheet

        $upload_file = $_FILES['file']['tmp_name'];
        //文件类型
//        $ext = strtolower(pathinfo($_FILES['file']['name'], PATHINFO_EXTENSION));

        //自动获取文件类型 (xlsx,xls,csv)
        $spreadsheet = IOFactory::load($upload_file);
        $worksheet = $spreadsheet->getActiveSheet();
        // 总行数
        $highestRow = $worksheet->getHighestRow();
        // 总列数
        $highestColumn = $worksheet->getHighestColumn();

        $lines = $highestRow - 1;
        if ($lines <= 0) {
            //todo,无数据处理
        }
        $arr = [];
        //第二行开始
        for ($row = 2; $row <= $highestRow; ++$row) {
            //getCellByColumnAndRow(1, $row) 对应列选择
            $order_id = $worksheet->getCellByColumnAndRow(1, $row)->getValue(); //编号
            $title = $worksheet->getCellByColumnAndRow(2, $row)->getValue(); //名称
            //todo,逻辑判断
        }
        //todo,其余操作
        
    }

$upload_file = $_FILES['file']['tmp_name'];
//自动获取文件类型 (xlsx,xls,csv)
$spreadsheet = IOFactory::load($upload_file);
//直接转为数组,避免上一种方法取值会出现表格内数据格式错误的问题
$data = $spreadsheet->getSheet(0)->toArray();  
var_dump($data);