1.使用composer安裝phpexcel類庫
打開項(xiàng)目根目錄的composer.json文件
將以下寫入到require下面
"phpoffice/phpexcel": "^1.8"
image.png
2.在項(xiàng)目根目錄執(zhí)行
composer require phpoffice/phpexcel
安裝成功后界弧，會(huì)注意到項(xiàng)目的vendor目錄下搭综，多出了一個(gè)phpoffice文件夾
3.讀取excel文件轉(zhuǎn)換成數(shù)組
public function readExcel()
{
$impfile = '/uploads/20200107/test.xlsx';
//取出文件后綴名
$temp_arr = explode(".", $impfile);
$file_ext = array_pop($temp_arr);
$file_ext = trim($file_ext);
$file_ext = strtolower($file_ext);
$extension = $file_ext;s's
if($extension!='xls' && $extension!='xlsx') {
return resultArray(['error' => '請(qǐng)上傳xls兑巾、xlsx文件格式']);
}
$objExcel = new \PHPExcel();
$filename = '.'.$impfile;
if($extension == 'xlsx') {
$objReader = \PHPExcel_IOFactory::createReader('Excel2007');
$objPHPExcel = $objReader->load($filename, $encode = 'utf-8');
}else if($extension == 'xls'){
$objReader = \PHPExcel_IOFactory::createReader('Excel5');
$objPHPExcel = $objReader->load($filename, $encode = 'utf-8');
}
$excel_array = $objPHPExcel->getsheet(0)->toArray(); //轉(zhuǎn)換為數(shù)組格式
unset($excel_array[0]);
if(empty($excel_array)){
return false;
}
return $excel_array;
}
