thinkphp3.2 下载Excel表格方法

最新推荐文章于 2022-03-23 14:35:22 发布

哎,喝不喝奶茶

最新推荐文章于 2022-03-23 14:35:22 发布

阅读量559

点赞数

分类专栏： php

本文链接：https://blog.csdn.net/qq_33679504/article/details/80631095

版权

php 专栏收录该内容

28 篇文章 0 订阅

订阅专栏

首先下载PHPExcel文件夹。如果找不到合适点击这里下载

将网上下载的PHPExcel文件夹放在 Thinkphp/Library/Org/Util 下


<?php 

    public function down(){

        $fileName = '学生信息表.xlsx';
        $headArr = [
            '姓名',
            '学号',
            '联系电话',
        ];
        $data = [
            [
                '张三',
                '001',
                '13512345678',
            ],
            [
                '李四',
                '002',
                '13612345678',
            ],
            [
                '王五',
                '003',
                '13712345678',
            ],
        ];

        $this -> getExcel($fileName,$headArr,$data);
    }


    private function getExcel($fileName,$headArr,$data){

        // 将网上下载的PHPExcel文件夹放在Thinkphp/Library/Org/Util下
        import("Org.Util.PHPExcel");
        import("Org.Util.PHPExcel.Writer.Excel5");
        import("Org.Util.PHPExcel.IOFactory.php");
        import("Org.Util.PHPExcel.Cell");

        //创建PHPExcel对象，注意，不能少了\
        $objPHPExcel = new \PHPExcel();
        $objProps = $objPHPExcel->getProperties();

        // 设置居中和列宽
        $objPHPExcel->getActiveSheet()->getStyle('A:Z')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(30);   
        $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(30);


        //设置表头
        $key = ord("A");
        foreach($headArr as $v){
            $colum = chr($key);
            $objPHPExcel->setActiveSheetIndex(0) ->setCellValue($colum.'1', $v);
            $key += 1;
        }


        $column = 2;
        $objActSheet = $objPHPExcel->getActiveSheet();
        foreach($data as $k => &$v){ //行写入
            $span = ord("A");
            $j = chr($span);
            foreach($v as $kk => $vv){// 列写入
                $j = chr($span);
                $objActSheet -> setCellValue($j.$column, $vv);
                $span++;
            }
            $column++;
        }
        $fileName = iconv("utf-8", "gb2312", $fileName);
        //设置活动单指数到第一个表,所以Excel打开这是第一个表
        $objPHPExcel->setActiveSheetIndex(0);
        ob_end_clean();
        ob_start();
        header('Content-Type: application/vnd.ms-excel');
        header("Content-Disposition: attachment;filename=\"$fileName\"");
        header('Cache-Control: max-age=0');
        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
        $objWriter->save('php://output'); //文件通过浏览器下载
        exit;
    }