phpExecl 내보내기 execl 테이블-PHP 튜토리얼-php.cn

phpExecl 내보내기 execl 테이블

不言

풀어 주다： 2023-03-24 12:24:01

원래의

1501명이 탐색했습니다.

이 문서의 내용은 execl 테이블을 내보내는 것에 관한 것입니다. 이제 특정 참조 값이 있습니다. 필요한 친구가 참조할 수 있습니다.

1: PHPExecl 플러그인 다운로드

다운로드 주소: https: //download.csdn.net/download/rainredhezhang/10359499

2: 해당 디렉터리에 넣습니다.

3: 일반 내보내기 방법 작성,

function exportexecl($data=[],$expCellName,$name="会员列表清单"){
    date_default_timezone_set(&#39;Asia/Shanghai&#39;);
    import(&#39;Vendor.Excel.PHPExcel&#39;);
    //获取数据
   
    $cellNum = count($expCellName);// 有多少列
    $dataNum = count($data);//有多少行
   
   $cellName = array(&#39;A&#39;,&#39;B&#39;,&#39;C&#39;,&#39;D&#39;,&#39;E&#39;,&#39;F&#39;,&#39;G&#39;,&#39;H&#39;,&#39;I&#39;,&#39;J&#39;,&#39;K&#39;,&#39;L&#39;,&#39;M&#39;,&#39;N&#39;,&#39;O&#39;,
         &#39;P&#39;,&#39;Q&#39;,&#39;R&#39;,&#39;S&#39;,&#39;T&#39;,&#39;U&#39;,&#39;V&#39;,&#39;W&#39;,&#39;X&#39;,&#39;Y&#39;,&#39;Z&#39;, &#39;AA&#39;,&#39;AB&#39;,&#39;AC&#39;,&#39;AD&#39;,&#39;AE&#39;,
         &#39;AF&#39;,&#39;AG&#39;,&#39;AH&#39;,&#39;AI&#39;,&#39;AJ&#39;,&#39;AK&#39;,&#39;AL&#39;,&#39;AM&#39;,&#39;AN&#39;,&#39;AO&#39;,&#39;AP&#39;,&#39;AQ&#39;,&#39;AR&#39;,&#39;AS&#39;,&#39;AT&#39;,
         &#39;AU&#39;,&#39;AV&#39;,&#39;AW&#39;,&#39;AX&#39;,&#39;AY&#39;,&#39;AZ&#39;);
    $objPHPExcel=new \PHPExcel();
    $objPHPExcel->getProperties()->setCreator(&#39;http://www.jb51.net&#39;)
            ->setLastModifiedBy(&#39;http://www.jb51.net&#39;)
            ->setTitle(&#39;Office 2007 XLSX Document&#39;)
            ->setSubject(&#39;Office 2007 XLSX Document&#39;)
            ->setDescription(&#39;Document for Office 2007 XLSX, generated using PHP classes.&#39;)
            ->setKeywords(&#39;office 2007 openxml php&#39;)
            ->setCategory(&#39;Result file&#39;);

   for($i=0;$i<$cellNum;$i++){
      $objPHPExcel->setActiveSheetIndex(0)->setCellValue($cellName[$i].&#39;1&#39;, $expCellName[$i][1]);
   }
   
   for($i=0;$i<$dataNum;$i++){
      for($j=0;$j<$cellNum;$j++){
         $objPHPExcel->getActiveSheet(0)->setCellValue($cellName[$j].($i+2), $data[$i][$expCellName[$j][0]]);
      }
   }

    $objPHPExcel->getActiveSheet()->setTitle($name);
    $objPHPExcel->setActiveSheetIndex(0);
    $filename=urlencode($name).&#39;_&#39;.date(&#39;Y-m-dHis&#39;);
    //*生成xls文件
    header(&#39;Content-Type: application/vnd.ms-excel&#39;);
    header(&#39;Content-Disposition: attachment;filename="&#39;.$filename.&#39;.xls"&#39;);
    header(&#39;Cache-Control: max-age=0&#39;);
    $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, &#39;Excel5&#39;);
    
    $objWriter->save(&#39;php://output&#39;);

    exit;
}

로그인 후 복사

4: 데이터 호출 방법 작성:

public function explodetradelog(){
		$list = [[&#39;userid&#39;=>1,&#39;username&#39;=>&#39;user1&#39;],[&#39;userid&#39;=2,&#39;username&#39;=>&#39;user2&#39;]];// 数据


                // 数据对应的表头。这里的第一个对应$list 的key值，第一个对应execl 的表头文字
		$ceilname = [
		[&#39;userid&#39;,&#39;ID&#39;],
		[&#39;username&#39;,&#39;用户名&#39;],
		];
                // 调用就可以了
		exportexecl($list,$ceilname,"用户信息");
}

로그인 후 복사