PHP實現excel匯出

標籤：

首先去下載PHPExcel類，地址http://phpexcel.codeplex.com/

方法如下第一步引入這個擴充類

1 Vendor(‘PHPExcel‘);

第二部就是方法了，下面簡單的實現方法

 1     public function phpExcel() 2     { 3 //        $list=array(array(‘dfcdf‘,‘測試‘,‘dfdfdsfd‘,‘dfd‘,‘dfdf‘),array(‘dfdsf‘,‘51策劃書‘,‘dfdsfd‘,‘efed‘,‘dfdf‘)); 4         $list = session(‘cash_list‘); 5         $phpExcel = new \PHPExcel(); 6         $phpExcel->getProperties() 7             ->setCreator(‘ShuLaiBao‘)//建立人 8             ->setLastModifiedBy(‘ShuLaiBao‘)//最後修改人 9             ->setTitle(‘Office 2007 XLSX Test Document‘)//標題10             ->setSubject(‘Office 2007 XLSX Test Document‘)//題目11             ->setDescription(‘Test document for Office 2007 XLSX, generated using PHP classes.‘)//描述12             ->setKeywords(‘office 2007 openxml php‘)13             ->setCategory(‘Test Result file‘);14         //設定當前的sheet15         $phpExcel->setActiveSheetIndex(0);16         //設定表頭17         $phpExcel->getActiveSheet()18             ->setCellValue(‘A1‘, ‘使用者‘)19             ->setCellValue(‘B1‘, ‘號‘)20             ->setCellValue(‘C1‘, ‘商戶訂單號‘)21             ->setCellValue(‘D1‘, ‘付款訂單號‘)22             ->setCellValue(‘E1‘, ‘發送時間‘);23         foreach ($list as $key => $value) {24             $phpExcel->getActiveSheet()25                 ->setCellValue(‘A‘ . ($key + 2), $value[‘user_login‘])26                 ->setCellValue(‘B‘ . ($key + 2), $value[‘re_user_name‘])27                 ->setCellValue(‘C‘ . ($key + 2), $value[‘mcn_billno‘])28                 ->setCellValue(‘D‘ . ($key + 2), $value[‘payment_no‘])29                 ->setCellValue(‘E‘ . ($key + 2), date(‘Y-m-d H:i:s‘, $value[‘send_time‘]));30         }31         // 設定sheet的標題32         $phpExcel->getActiveSheet()->setTitle(‘發送記錄‘);33         // 建立檔案格式寫入對象執行個體, uncomment34         //$objWriter = PHPExcel_IOFactory::createWriter($phpExcel,‘Excel5‘);35         //$objWriter = new \PHPExcel_Writer_Excel5($phpExcel);     // 用於其他版本格式36         //$objWriter = new PHPExcel_Writer_Excel2007($objExcel); // 用於 2007 格式37         $objWriter = new \PHPExcel_Writer_Excel5($phpExcel);38         //設定檔案名稱39         $filename = date(‘Y-m-d H:i:s‘, time()) . ‘_紅包發送記錄.xls‘;40         //設定header41 //        ob_clean();42 //        flush();43         header("Content-Type: application/force-download");44         header("Content-Type: application/octet-stream");45         header("Content-Type: application/download");46         header(‘Content-Disposition:inline;filename="‘ . $filename . ‘"‘);47         header("Content-Transfer-Encoding: binary");48         header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");49         header("Cache-Control: must-revalidate, post-check=0, pre-check=0");50         header("Pragma: no-cache");51         $objWriter->save(‘php://output‘);52         die();//終止執行53     }

 

PHP實現excel匯出