https://www.cnblogs.com/itwlp/p/11109280.html ``` $xlsx = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx(); // dump($xlsx); //加载文件 $excel = $xlsx->load("鸿合科技-投资者关系-公司治理文档整理.xlsx"); //获取活动的excel sheet $active_sheet = $excel ->getActiveSheet(); // dump($active_sheet); //获取sheet列数 $cols = $active_sheet->getHighestColumn(); // dump($cols); //获取行数 $rows = $active_sheet->getHighestRow(); // dump($rows); $data = []; for ($r=1;$r<=$rows;$r++){ //行 $tmp = []; for ($c = 'A'; $c <= $cols; $c++){ //列值 $tmp[]= $active_sheet->getCell($c.$r)->getValue(); } $data[] = $tmp; } $data=array_reverse($data); dump($data); foreach ($data as $key => &$value) { if ($key==0) { $key='title'; } //章程1、制度2、规则3 if ($value[1]=='章程') { $value[1]='1'; }else if ($value[1]=='制度') { $value[1]='2'; }else{ $value[1]='3'; } $value[2]=strtotime($value[2]); unset($value[4]); $key_arr=array('title','govern_type','create_time','govern_file'); $value=array_combine ($key_arr , $value); $value['update_time']=$value['create_time']; $value['cate_id']='46'; } dump($data); \think\facade\Db::name('govern_download')->insertAll($data); die; ```