别再用PHPexcel啦!用这个PHPoffice(以CI框架为例)

来源:csdn博客分类: 文章浏览史发布时间:2020-09-23 15:43:41 最后更新:2020-09-23 浏览:614

转载声明：

本文为摘录自“csdn博客”，版权归原作者所有。

原文链接:

https://blog.csdn.net/assasin0308/article/details/90633...

温馨提示：

为了更好的体验，请点击原文链接进行浏览

摘录时间：

2020-09-23 15:43:41

1. 首先你得有Ci框架才行啊.....codeigniter

composer create-project codeigniter/framework

2. 直接撸代码..下载安装PHPoffice.....

composer require phpoffice/phpspreadsheet

3. 接下来,你懂得,封装一个模型方法,哪里使(bu)用(hui)哪(dian)里(na)调(li).......

ExportXlsModel.php

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

class ExportXlsModel extends CI_Model{
    /**
     * 导出excel
     * @param $data
     * @param string $title
     */
    public function export_excel($data, $title = '未命名.xlsx') {
       // var_dump($data);
        ini_set ('memory_limit', '1024M');
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        foreach ($data as $key1=>$sub_data) { //列
            foreach ($sub_data as $key2=>$item) { //行
                $sheet->setCellValueExplicitByColumnAndRow($key2+1, $key1+1,$item,'s');
            }
        }
        unset($data);
        $writer = new Xlsx($spreadsheet);
        unset($spreadsheet);
//      $writer->save($title);
        header("Pragma: public");
        header("Expires: 0");
        header('Access-Control-Allow-Origin:*');
        header('Access-Control-Allow-Headers:content-type');
        header('Access-Control-Allow-Credentials:true');
        header("Cache-Control:must-revalidate, post-check=0, pre-check=0");
        header("Content-Type:application/force-download");
        header("Content-Type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
        header("Content-Type:application/octet-stream");
        header("Content-Type:application/download");;
        header("Content-Disposition:attachment;filename=$title");
        header("Content-Transfer-Encoding:binary");
        $writer->save('php://output');
        exit();
    }
}

4. 用一下(ha)....

//把数据组装出呢个下面结构就可以啦......

$arr = [
  ['id','name','age','sex'],  //这一行是表头
  [1,'assasin',25,'male'], //第一行数据
  [2,'bob',20,'male'],  //第二行数据
  [3,'juli',18,'female'] //第三行数据
];

 $this->load->model('exportXlsModel');
 $this->exportXlsModel->export_excel($export_array,'导出结果.xlsx');