php实现利用phpexcel导出数据

前端技术 2023/09/05 PHP

废话不多说，直接上代码吧

复制代码 代码如下:

public function export_data($data = array())
    {
        # code...
        include_once(APP_PATH.\'Tools/PHPExcel/Classes/PHPExcel/Writer/IWriter.php\') ;
        include_once(APP_PATH.\'Tools/PHPExcel/Classes/PHPExcel/Writer/Excel5.php\') ;
        include_once(APP_PATH.\'Tools/PHPExcel/Classes/PHPExcel.php\') ;
        include_once(APP_PATH.\'Tools/PHPExcel/Classes/PHPExcel/IOFactory.php\') ;
        $obj_phpexcel = new PHPExcel();
        $obj_phpexcel->getActiveSheet()->setCellValue(\'a1\',\'Key\');
        $obj_phpexcel->getActiveSheet()->setCellValue(\'b1\',\'Value\');       
        if($data){
            $i =2;
            foreach ($data as $key => $value) {
                # code...
                $obj_phpexcel->getActiveSheet()->setCellValue(\'a\'.$i,$value);
                $i++;
            }
        }   

        $obj_Writer = PHPExcel_IOFactory::createWriter($obj_phpexcel,\'Excel5\');
        $filename = \"outexcel.xls\";

        header(\"Content-Type: application/force-download\");
        header(\"Content-Type: application/octet-stream\");
        header(\"Content-Type: application/download\");
        header(\'Content-Disposition:inline;filename=\"\'.$filename.\'\"\');
        header(\"Content-Transfer-Encoding: binary\");
        header(\"Last-Modified: \" . gmdate(\"D, d M Y H:i:s\") . \" GMT\");
        header(\"Cache-Control: must-revalidate, post-check=0, pre-check=0\");
        header(\"Pragma: no-cache\");
        $obj_Writer->save(\'php://output\');
    }

本文地址：https://www.stayed.cn/item/12451

转载请注明出处。

本站部分内容来源于网络,如侵犯到您的权益,请 联系我

我的博客

人生若只如初见，何事秋风悲画扇。

我的标签

随笔档案