1.需要引入PHPExcel,放在ThinkPHP/Library/Vendor/目录下
2.php代码
if (!empty($_FILES['imgFile'])) {
$upload = new \Think\Upload();// 实例化上传类
$upload->maxSize = 3145728 ;// 设置附件上传大小
$upload->exts = array('xlsx', 'xls');// 设置附件上传类型
$upload->rootPath = 'Public/cdel/'; // 设置附件上传根目录
$upload->savePath = ''; // 设置附件上传(子)目录
// 上传文件
$info = $upload->upload();
if(!$info) {// 上传错误提示错误信息
$this->error($upload->getError());
// }else{// 上传成功
// $this->success('上传成功!');
}
vendor("PHPExcel.PHPExcel");
// dump($info['imgFile']['savepath']);exit;
$file_name= 'Public/cdel/'.$info['imgFile']['savepath'].$info['imgFile']['savename'];
$objReader = \PHPExcel_IOFactory::createReader('Excel5');
$objPHPExcel = $objReader->load($file_name,$encode='utf-8');
$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow(); // 取得总行数
$highestColumn = $sheet->getHighestColumn(); // 取得总列数
for($i=3;$i<=$highestRow;$i++){//$i=3 数据开始行为3
$data['name'] = $objPHPExcel->getActiveSheet()->getCell("A".$i)->getValue();
$data['email'] = $objPHPExcel->getActiveSheet()->getCell("B".$i)->getValue();
$data['departname'] = $objPHPExcel->getActiveSheet()->getCell("C".$i)->getValue();
}