PHPExcel导出示例

忘是亡心i 2022-06-13 06:54 321阅读 0赞

## 导出方法封装 ##

<?php /** * Created by PhpStorm. * User: Administrator * Date: 2017/6/8/008 * Time: 17:14 */ namespace Common\Utils; class ExcelExporter { /** * @param $data 数据 * @param $file_name 文件名 * @param $titles 数据的行头,key和数据的key一一对应 */ public static function export(array $data, $file_name,array $titles) { import('Org.Util.PHPExcel'); //include "PHPExcel.php"; $letters = ['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']; $objPHPExcel = new \PHPExcel(); /*以下是一些设置 ，什么作者 标题啊之类的*/ $objPHPExcel->getProperties() ->setCreator("创建者") ->setLastModifiedBy("修改者") ->setTitle("标题") ->setSubject("哈哈哈") ->setDescription("描述") ->setKeywords("关键字") ->setCategory("分类"); $objPHPExcel->setActiveSheetIndex(0); $sheet = $objPHPExcel->getActiveSheet(); $col = 1; foreach ($titles as $key=>$name){ $sheet->setCellValue($letters[$col-1].'1',$name); $col++; } $row = 2; $col = 1; foreach ($data as $k => $v) { foreach ($titles as $key => $name){ $sheet->setCellValue($letters[$col-1].$row,$v[$key]); $col++; } $col = 1; $row++; } $objPHPExcel->setActiveSheetIndex(0); header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="' . $file_name . '.xls"'); header('Cache-Control: max-age=0'); $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); exit; } }

## 调用 ##

$data = [
              [
                   'name' => 'name-1',
                   'age' => '21',
                   'sex' => '男',
               ],[
                   'name' => 'name-2',
                   'age' => '41',
                   'sex' => '男',
               ],[
                   'name' => 'name-3',
                   'age' => '22',
                   'sex' => '女',
               ]
           ];
           //titles的key要和数据data的key一致
           $titles = [
               'name' => '名称',
               'age' => '年龄',
               'sex' => '性别',
           ];
           ExcelExporter::export($data,'test',$titles);

## 效果展示 ##

![这里写图片描述][SouthEast]

[SouthEast]: /images/20220613/f38204ceaa364ad5a5827782fd0d0c96.png