phpExcel示例

         include ROOTPATH.'/excel/PHPExcel.php';
         include ROOTPATH.'/excel/PHPExcel/Writer/Excel2007.php';
         include ROOTPATH.'/excel/phpExcel/IOFactory.php';
        
         $status = $this -> input -> get('userstatus');
         $nickname = $this -> input -> get('nickname');
         $datestart = $this -> util -> date_to_timestamp($this -> input -> get('datestart'));
         $dateend = $this -> util -> date_to_timestamp($this -> input -> get('dateend'));
         $type = $this -> input -> get('type');
         $order = $this -> input -> get('order');
         $pninfo = $this -> input -> get('pninfo');
         if(!$pninfo){
             $pninfo = 1000;
         }
         
         $this->UserModel->setOrder($order);
         $this->UserModel->setCondition($nickname,$status ,$datestart,$dateend,$type);
         
         $list =  $this->UserModel->pageview(0,$pninfo);
         
         $objExcel = new PHPExcel();    
         $objExcel->getProperties()->setCreator("toxic");  
         $objExcel->getProperties()->setLastModifiedBy("toxic");  
         $objExcel->getProperties()->setTitle("Office 2007 XLS Test Document");  
         $objExcel->getProperties()->setSubject("Office 2007 XLS Test Document");  
         $objExcel->getProperties()->setDescription("Test document for Office 2007 XLS, generated using PHP classes.");  
         $objExcel->getProperties()->setKeywords("office 2007 openxml php");  
         $objExcel->getProperties()->setCategory("Test result file");  
         
         $objExcel->setActiveSheetIndex(0);
         $objActSheet = $objExcel->getActiveSheet();
         $objActSheet->setTitle('9i');
         
         $objActSheet->setCellValue('A1', '帐号');
         $objActSheet->setCellValue('B1', '昵称');
         $objActSheet->setCellValue('C1', '组别');
         $objActSheet->setCellValue('D1', '注册时间');
         $objActSheet->setCellValue('E1', '身高');
         $objActSheet->setCellValue('F1', 'QQ');
         $objActSheet->setCellValue('G1', 'YY');
         $objActSheet->setCellValue('H1', '金豆');
         $objActSheet->setCellValue('I1', '消耗金豆');
         $objActSheet->setCellValue('J1', '花朵');
         $objActSheet->setCellValue('K1', '消耗花朵');
         $objActSheet->setCellValue('L1', '状态');
         
         for($i = 0 ; $i<count($list); $i++){
              $k = $i+2;
              $objActSheet->setCellValue('A'.$k, $list[$i]['email']);
             $objActSheet->setCellValue('B'.$k, $list[$i]['nickname']);
             $objActSheet->setCellValue('C'.$k, $list[$i]['type']);
             $objActSheet->setCellValue('D'.$k, $list[$i]['restime']);
             $objActSheet->setCellValue('E'.$k, $list[$i]['inch']);
             $objActSheet->setCellValue('F'.$k, $list[$i]['qq']);
             $objActSheet->setCellValue('G'.$k, $list[$i]['yy']);
             $objActSheet->setCellValue('H'.$k, $list[$i]['goldbean']);
             $objActSheet->setCellValue('I'.$k, $list[$i]['usedgoldbeans']);
             $objActSheet->setCellValue('J'.$k, $list[$i]['flowers']);
             $objActSheet->setCellValue('K'.$k, $list[$i]['usedflowers']);
             $objActSheet->setCellValue('L'.$k, $list[$i]['status']);
         }
         
         
         $objExcel->getActiveSheet()->getColumnDimension('A')->setWidth(30);  
         $objExcel->getActiveSheet()->getColumnDimension('B')->setWidth(30);  
         $objExcel->getActiveSheet()->getColumnDimension('C')->setWidth(30);  
         $objExcel->getActiveSheet()->getColumnDimension('D')->setWidth(30);  
         $objExcel->getActiveSheet()->getColumnDimension('E')->setWidth(30);  
         $objExcel->getActiveSheet()->getColumnDimension('F')->setWidth(30);
         $objExcel->getActiveSheet()->getColumnDimension('G')->setWidth(30);
         $objExcel->getActiveSheet()->getColumnDimension('H')->setWidth(30);
         $objExcel->getActiveSheet()->getColumnDimension('I')->setWidth(30);
         $objExcel->getActiveSheet()->getColumnDimension('J')->setWidth(30);
         $objExcel->getActiveSheet()->getColumnDimension('K')->setWidth(30);
         $objExcel->getActiveSheet()->getColumnDimension('L')->setWidth(30);
         
        //PHP类phpExcel设置填充颜色
         $objExcel->getActiveSheet()->getStyle('A1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
         $objExcel->getActiveSheet()->getStyle('A1')->getFill()->getStartColor()->setARGB('FF808080');
         
         $objExcel->getActiveSheet()->getStyle('B1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
         $objExcel->getActiveSheet()->getStyle('B1')->getFill()->getStartColor()->setARGB('FF808080');
         
         $objExcel->getActiveSheet()->getStyle('C1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
         $objExcel->getActiveSheet()->getStyle('C1')->getFill()->getStartColor()->setARGB('FF808080');
         
         $objExcel->getActiveSheet()->getStyle('D1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
         $objExcel->getActiveSheet()->getStyle('D1')->getFill()->getStartColor()->setARGB('FF808080');
         
         $objExcel->getActiveSheet()->getStyle('E1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
         $objExcel->getActiveSheet()->getStyle('E1')->getFill()->getStartColor()->setARGB('FF808080');
         
         $objExcel->getActiveSheet()->getStyle('F1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
         $objExcel->getActiveSheet()->getStyle('F1')->getFill()->getStartColor()->setARGB('FF808080');
         
         $objExcel->getActiveSheet()->getStyle('G1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
         $objExcel->getActiveSheet()->getStyle('G1')->getFill()->getStartColor()->setARGB('FF808080');
         
         $objExcel->getActiveSheet()->getStyle('H1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
         $objExcel->getActiveSheet()->getStyle('H1')->getFill()->getStartColor()->setARGB('FF808080');
         
         $objExcel->getActiveSheet()->getStyle('J1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
         $objExcel->getActiveSheet()->getStyle('J1')->getFill()->getStartColor()->setARGB('FF808080');
         
         $objExcel->getActiveSheet()->getStyle('K1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
         $objExcel->getActiveSheet()->getStyle('K1')->getFill()->getStartColor()->setARGB('FF808080');
         
         $objExcel->getActiveSheet()->getStyle('L1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
         $objExcel->getActiveSheet()->getStyle('L1')->getFill()->getStartColor()->setARGB('FF808080');
         
         $objExcel->getActiveSheet()->getStyle('I1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
         $objExcel->getActiveSheet()->getStyle('I1')->getFill()->getStartColor()->setARGB('FF808080');
         
         $objExcel->getActiveSheet()->getHeaderFooter()->setOddHeader('&L&BPersonal cash register&RPrinted on &D');  
         $objExcel->getActiveSheet()->getHeaderFooter()->setOddFooter('&L&B' . $objExcel->getProperties()->getTitle() . '&RPage &P of &N');  

　　　　　

//设置文字在单元格居中还是居左居右
//$objExcel->getActiveSheet()-> getStyle('A1') ->getAlignment() ->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); 

// 设置页方向和规模  $objExcel->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_PORTRAIT); $objExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4); $objExcel->setActiveSheetIndex(0); $timestamp = time(); header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); header('Content-Disposition: attachment;filename="links_out'.$timestamp.'.xlsx"'); header('Cache-Control: max-age=0'); $objWriter = PHPExcel_IOFactory::createWriter($objExcel, 'Excel2007'); $objWriter->save('php://output'); exit;