php导出excel

	require_once "Excel/PHPExcel.php";
	require_once 'Excel/PHPExcel/IOFactory.php';
	require_once 'Excel/PHPExcel/Writer/Excel5.php';
        $resultPHPExcel = new PHPExcel();
        $modelClass = 'app\com\simtoon\models\FreeCar';
        $data = YiiComm::executeByMethod($modelClass, 'findAllData', $_REQUEST);


        $resultPHPExcel->getActiveSheet()->setCellValue('A1', '序号');
        $resultPHPExcel->getActiveSheet()->setCellValue('B1', '携带参数');
        $resultPHPExcel->getActiveSheet()->setCellValue('C1', '手机号码');
        $resultPHPExcel->getActiveSheet()->setCellValue('D1', '时间');
        $resultPHPExcel->getActiveSheet()->setCellValue('E1', '本地IP');


        $resultPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
        $resultPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(30);
        $resultPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(30);
        $resultPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(30);
        $resultPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(30);

        // 设置内容居中
        $resultPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $resultPHPExcel->getActiveSheet()->getStyle('B1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $resultPHPExcel->getActiveSheet()->getStyle('C1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $resultPHPExcel->getActiveSheet()->getStyle('D1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $resultPHPExcel->getActiveSheet()->getStyle('E1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        
        $i = 2;

        $typename='手机号信息';
       
        foreach($data as $item){
            //设置格式为文本
            $resultPHPExcel->getActiveSheet()->getStyle('A')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);
            $resultPHPExcel->getActiveSheet()->getStyle('B')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);
            $resultPHPExcel->getActiveSheet()->setCellValue('A' . $i, $i-1);
            $resultPHPExcel->getActiveSheet()->setCellValue('B' . $i, $item['form']);
            $resultPHPExcel->getActiveSheet()->setCellValue('C' . $i, $item['phone']);
            $resultPHPExcel->getActiveSheet()->setCellValue('D' . $i, $item['create_time']);
            $resultPHPExcel->getActiveSheet()->setCellValue('E' . $i, $item['ip']);
            $i ++;
        }

        $outputFileName =$typename.'详情.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" );

php excel 类文件地址：https://gitee.com/simper_zxb/php-excel