• CodeIgniterCodeigniter+PHPExcel导出数据到Excel文件


    解压压缩包里的Classes文件夹中的内容到applicationlibraries目录下,目录结构如下:
    --applicationlibrariesPHPExcel.php
    --applicationlibrariesPHPExcel(文件夹)
    修改applicationlibrariesPHPExcelIOFactory.php文件
    --将其类名从PHPExcel_IOFactory改为IOFactory,遵从CI类命名规则。
    --将其构造函数改为public

            $this->load->library('PHPExcel');
            $this->load->library('PHPExcel/IOFactory');
            $resultPHPExcel = new PHPExcel();
            $resultPHPExcel->getActiveSheet()->setCellValue('A1', '项目'); 
            $resultPHPExcel->getActiveSheet()->setCellValue('B1', '结果'); 
            $resultPHPExcel->getActiveSheet()->setCellValue('C1', '数量'); 
            $i = 2; 
            foreach($m_data['jc_fia'] as $key){ 
                $resultPHPExcel->getActiveSheet()->setCellValue('A' . $i, $key[0]); 
                $resultPHPExcel->getActiveSheet()->setCellValue('B' . $i, $key[1]); 
                $resultPHPExcel->getActiveSheet()->setCellValue('C' . $i, $key[0]); 
                $i ++; 
            }
            $outputFileName = "123.xls";
            $xlsWriter = new PHPExcel_Writer_Excel5($resultPHPExcel); 
            header("Content-Type: application/force-download"); 
            header("Content-Type: application/octet-stream"); 
            header("Content-Type: application/download"); 
            header('Content-Disposition:inline;filename="'.$outputFileName.'"'); 
            header("Content-Transfer-Encoding: binary"); 
            header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); 
            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"); 
            $xlsWriter->save( "php://output" );
  • 相关阅读:
    最近很烦心情糟糕透了
    面试心得
    CSS之按钮过滤
    JavaScript之动态背景登陆表单
    VsCode自定义快捷键,一次运行两个或多个Command命令
    Go优化浅谈
    go语言圣经第六章笔记
    go 语言圣经第六章习题
    go 内存对齐
    go语言圣经第五章部分习题
  • 原文地址:https://www.cnblogs.com/whlives/p/3910781.html
Copyright © 2020-2023  润新知