1,安装 phpexcel
composer require phpoffice/phpexcel
安装成功后,vendor文件夹下会有phpoffice文件夹
2,common.php 中加入导出excel方法
function tbld_Importexcel($filename,$excelname){
$objPHPExcel=\PHPExcel_IOFactory::load($filename);
$excelonekey=['A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R',
'S','T','U','V','W','X','Y','Z','AA','AB','AC','AD','AE','AF','AG','AH','AI','AJ'];
$excelonename=array();$excelkeyname=array();
foreach ($excelonekey as $val){
$name=$objPHPExcel->getActiveSheet()->getCell($val.'1')->getValue();
foreach ($excelname as $k=>$v){
if($v === $name){
$excelkeyname[$val]=$k;
$excelonename["$k"]=$name;
}
}
}
if(count($excelonename)<count($excelname)){
return ['status'=>0,'message'=>'导入excel格式错误,请下载最新导入模板格式!'];
}
$sheet=$objPHPExcel->getSheet(0);//获取第一个工作表
$highestRow=$sheet->getHighestRow();//取得总行数
$highestColumn=count($excelonename); //取得总列数
$ChangeDatas = [];
for($j=2;$j<=$highestRow;$j++){
$excelrowarr=[];
for($k='0';$k<=$highestColumn;$k++){
$excelkey=$excelonekey[$k];
if(isset($excelkeyname["$excelkey"])){
$keyname=$excelkeyname["$excelkey"];
if($keyname=='consumables_purchase_time' || $keyname=='consumables_repair_time' ||
$keyname=='warehouse_purchase_time' || $keyname=='warehouse_repair_time'){
$excelrowarr["$keyname"]=excelTime($objPHPExcel->getActiveSheet()->getCell("$excelkey$j")->getValue());
}else{
$excelrowarr["$keyname"]=$objPHPExcel->getActiveSheet()->getCell("$excelkey$j")->getValue();
}
}
}
array_push($ChangeDatas, $excelrowarr);
}
if(!$ChangeDatas){
return ['status'=>0,'message'=>'没有获取到导入的excel数据!'];
}
return ['status'=>1,'message'=>'读取数据成功!','data'=>$ChangeDatas];
}
3,怎么使用这个方法
$file = $_FILES['file'];
/*上传文件存在判断*/
if (empty($file['name']))
{
return '请选择要上传的excel!';
}
/*文件来源判定*/
if (!is_uploaded_file($file['tmp_name']))
{
return '文件来源不明!';
}
$excelname=array(
'name'=>'名字', //名字,对应excel上面的目录
'page'=>'年龄',
'sex'=>'性别'
);
$excelarr=tbld_Importexcel($file['tmp_name'],$excelname);
var_dump($excelarr);