Tp5.1使用导出Excel

最新推荐文章于 2023-10-17 12:06:46 发布

哲学家乔布斯

最新推荐文章于 2023-10-17 12:06:46 发布

阅读量2k

点赞数

CC 4.0 BY-SA版权

分类专栏： PHP tp5.1

本文链接：https://blog.youkuaiyun.com/qq_36598009/article/details/89880738

PHP 同时被 2 个专栏收录

16 篇文章

订阅专栏

tp5.1

3 篇文章

订阅专栏

博客介绍了Composer的安装，提供了安装链接https://www.phpcomposer.com/，还提及了Composer的引入和使用相关内容，主要围绕信息技术领域的开发工具展开。

首先安装 composer 链接地址 https://www.phpcomposer.com/

composer require phpoffice/phpexcel

一：引入

use PHPExcel;
use PHPExcel_IOFactory;

二：使用

$objPHPExcel = new \PHPExcel();
        // 设置sheet
        $objPHPExcel->setActiveSheetIndex(0);
        // 设置列的宽度
        $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
        // 设置表头
        $objPHPExcel->getActiveSheet()->SetCellValue('A1', '激活码');
        $objPHPExcel->getActiveSheet()->SetCellValue('B1', '学段');
        $objPHPExcel->getActiveSheet()->SetCellValue('C1', '使用情况');
        //存取数据
        $num = 2;
        foreach ($list as $k => $v) {
            $objPHPExcel->getActiveSheet()->SetCellValue('A' . $num, $v['title']);
            $objPHPExcel->getActiveSheet()->SetCellValue('B' . $num, $v['title']);
            $objPHPExcel->getActiveSheet()->SetCellValue('C' . $num, $v['title']);
            $num++;
        }
        // 文件名称
        $fileName = "激活码" . date('Y-m-d', time()) . rand(1, 1000);
        $xlsName = iconv('utf-8', 'gb2312', $fileName);
        // 设置工作表名
        $objPHPExcel->getActiveSheet()->setTitle('sheet');
        //下载 excel5与excel2007
        $objWriter = new \PHPExcel_Writer_Excel5($objPHPExcel);
        ob_end_clean();     // 清除缓冲区,避免乱码
        header("Pragma: public");
        header("Expires: 0");
        header("Cache-Control:must-revalidate,post-check=0,pre-check=0");
        header("Content-Type:application/force-download");
        header("Content-Type:application/vnd.ms-execl;charset=UTF-8");
        header("Content-Type:application/octet-stream");
        header("Content-Type:application/download");
        header("Content-Disposition:attachment;filename=" . $xlsName . ".xls");
        header("Content-Transfer-Encoding:binary");
        $objWriter->save("php://output");