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];
}
}