php excel导入数据

excel导入数据

       //$filename 填写需要导入的文件名
        $excel = PHPExcel_IOFactory::load($filename);
        if ($excel == false) {
            $this->showMessage('加截excel文件失败', ['autoClose' => 5000]);
        }

        $sheet = $excel->getActiveSheet();
        $highestRow = $sheet->getHighestRow();
        for ($i = 1; $i <= $highestRow; $i++) {
            $phone[] = $sheet->getCell('A' . $i)->getValue();
        }
        unset($phone[0]);
        foreach ($phone as $value) {
            $str = explode('-', $value);
            if (isset($str[1]) && $str[1]) {
                $array[] = $str[1];
            }
        }