当前位置: 首页>>代码示例>>PHP>>正文

PHP PHPExcel_Style_Color::setRGB方法代码示例

本文整理汇总了PHP中PHPExcel_Style_Color::setRGB方法的典型用法代码示例。如果您正苦于以下问题：PHP PHPExcel_Style_Color::setRGB方法的具体用法？PHP PHPExcel_Style_Color::setRGB怎么用？PHP PHPExcel_Style_Color::setRGB使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类PHPExcel_Style_Color的用法示例。


在下文中一共展示了PHPExcel_Style_Color::setRGB方法的9个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: setStyle

 public function setStyle($cellRange, $fontFamily = 'Arial', $fontSize = 10, $colorRGB = '00000000', $bold = false, $italic = false, $underline = false)
 {
     require_once \GO::config()->root_path . 'go/vendor/PHPExcel/PHPExcel/Style.php';
     require_once \GO::config()->root_path . 'go/vendor/PHPExcel/PHPExcel/Style/Font.php';
     require_once \GO::config()->root_path . 'go/vendor/PHPExcel/PHPExcel/Style/Color.php';
     $colorObj = new \PHPExcel_Style_Color();
     $colorObj->setRGB($colorRGB);
     $fontObj = new \PHPExcel_Style_Font();
     $fontObj->setName($fontFamily);
     $fontObj->setSize($fontSize);
     $fontObj->setColor($colorObj);
     $fontObj->setBold($bold);
     $fontObj->setItalic($italic);
     $fontObj->setUnderline($underline);
     $styleObj = new \PHPExcel_Style();
     $styleObj->setFont($fontObj);
     $this->getActiveSheet()->setSharedStyle($styleObj, $cellRange);
 }
开发者ID:ajaboa，项目名称:crmpuan，代码行数:18，代码来源:Excel.php

示例2: PHPExcel

require_once 'const.php';
require_once 'PHPExcel.php';
$_dir = $_SERVER['DOCUMENT_ROOT'] . TEMP_DIR;
/* 読込 */
/*
$xls = PHPExcel_IOFactory::load($_dir.'/EXCEL_DATA.xlsx');

$xls->setActiveSheetIndex(0);
$sheet = $xls->getActiveSheet();

var_dump($sheet->getCell('B2').$sheet->getCell('C2'));
*/
/* 新規作成 */
$xls = new PHPExcel();
$sheet = $xls->setActiveSheetIndex(0);
$sheet->setCellValue('A1', '氏名', false);
$sheet->setCellValue('A2', '木島　仁', false);
$sheet->setCellValue('B1', '電話番号', false);
$sheet->setCellValue('B2', '03-5298-8868', false);
$sheet->setCellValue('C1', '更新日', false);
$sheet->setCellValue('C2', date('y/m/d'), false);
$sheet->getStyle('A1:C1')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$color = new PHPExcel_Style_Color();
$color->setRGB('ffcccc');
$color2 = new PHPExcel_Style_Color();
$color2->setRGB('ff6666');
$sheet->getStyle('A1:C1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_GRADIENT_LINEAR);
$sheet->getStyle('A1:C1')->getFill()->setStartColor($color);
$sheet->getStyle('A1:C1')->getFill()->setEndColor($color2);
$writer = PHPExcel_IOFactory::createWriter($xls, 'Excel2007');
$writer->save($_dir . '/WriteSample.xlsx');
开发者ID:kjkoma，项目名称:HelloPHPWorld，代码行数:31，代码来源:excel.php

示例3: 

$activeSheet->setCellValue('L5', $count4);
$activeSheet->setCellValue('M5', $count5);
$activeSheet->setCellValue('N5', $count6);
$activeSheet->setCellValue('O5', $count7);
$activeSheet->mergeCells('B9:B' . ($num - 1));
$activeSheet->getStyle('B9:B' . ($num - 1))->applyFromArray($canhgiua);
$activeSheet->getStyle('B9:B' . ($num - 1))->applyFromArray($indam);
$activeSheet->getStyle('C9:C' . (count($arr) + 9))->applyFromArray($canhgiua);
for ($i = 'E'; $i <= 'O'; $i++) {
    $activeSheet->getStyle($i . '9:' . $i . (count($arr) + 9))->applyFromArray($canhgiua);
}
$activeSheet->getStyle('D9:D' . (count($arr) + 9))->applyFromArray($canhtrai);
$activeSheet->getStyle('P9:P' . (count($arr) + 9))->applyFromArray($canhtrai);
$activeSheet->getStyle('Q9:Q' . (count($arr) + 9))->applyFromArray($canhtrai);
$phpColor = new PHPExcel_Style_Color();
$phpColor->setRGB('FF0000');
$activeSheet->setCellValue('D' . ($count + 9 + 6), 'Ghi chú:');
$activeSheet->getStyle('D' . ($count + 9 + 6))->applyFromArray($gachdit);
$activeSheet->getStyle('D' . ($count + 9 + 6))->applyFromArray($innghieng);
$activeSheet->getStyle('D' . ($count + 9 + 6))->applyFromArray($indam);
$activeSheet->getStyle('D' . ($count + 9 + 6))->getFont()->setColor($phpColor);
$objRichText = new PHPExcel_RichText();
$objBold = $objRichText->createTextRun('CÔNG VIỆC:');
$objBold->getFont()->setBold(true);
$objRichText->createText(' Ghi tên công việc mà mình làm thực tế.');
$activeSheet->setCellValue('D' . ($count + 9 + 7), $objRichText);
$activeSheet->mergeCells('D' . ($count + 9 + 7) . ':O' . ($count + 9 + 7));
unset($objBold);
$objRichText = new PHPExcel_RichText();
$objBold = $objRichText->createTextRun('MÃ DỰ ÁN:');
$objBold->getFont()->setBold(true);
开发者ID:phucdnict，项目名称:cbcc_05062015，代码行数:31，代码来源:default_excel_baocaotuan.php

示例4: foreach

             }
             $objPHPExcel->getActiveSheet()->setCellValue($cols . ($i + 1), $v);
             if (!empty($row['color']) && $k == $locate->Translate("answered duration")) {
                 $colorcell = $cols . ($i + 1) . ":" . $cols . ($i + 1);
                 $BackgroundColor = new PHPExcel_Style_Color();
                 $BackgroundColor->setRGB($row['color']);
                 $objPHPExcel->getActiveSheet()->getStyle($colorcell)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
                 $objPHPExcel->getActiveSheet()->getStyle($colorcell)->getFill()->setStartColor($BackgroundColor);
             }
         } else {
             //$objPHPExcel->getActiveSheet()->mergeCells(’A18:E22′);合并单元格方法
             //给单元格赋背景色
             if (!empty($row['color']) && $k == $locate->Translate("answered duration")) {
                 $colorcell = $cols . ($i + 1) . ":" . $cols . ($i + 1);
                 $BackgroundColor = new PHPExcel_Style_Color();
                 $BackgroundColor->setRGB($row['color']);
                 $objPHPExcel->getActiveSheet()->getStyle($colorcell)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
                 $objPHPExcel->getActiveSheet()->getStyle($colorcell)->getFill()->setStartColor($BackgroundColor);
             }
             if (is_numeric($v)) {
                 $isnumber[$cols] = 1;
             }
             $objPHPExcel->getActiveSheet()->setCellValue($cols . ($i + 1), $v);
         }
     }
     $i++;
 }
 foreach ($isnumber as $key => $value) {
     $objPHPExcel->getActiveSheet()->getColumnDimension($key)->setAutoSize(true);
 }
 $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
开发者ID:ljhcj，项目名称:IRISCC，代码行数:31，代码来源:dataexport.php

示例5: excelgeneration

 public function excelgeneration()
 {
     $this->load->library('excel');
     $this->load->model('reportsmodel');
     $data = array();
     $postdesignation = $postinterest = $postproduct = $postexperience = $postprofessional = $postknowby = array();
     if (!empty($this->input->post('designationselect'))) {
         $postdesignation = $this->input->post('designationselect');
     }
     if (!empty($this->input->post('interestselect'))) {
         $postinterest = $this->input->post('interestselect');
     }
     if (!empty($this->input->post('productselect'))) {
         $postproduct = $this->input->post('productselect');
     }
     if (!empty($this->input->post('experienceselect'))) {
         $postexperience = $this->input->post('experienceselect');
     }
     if (!empty($this->input->post('professionalselect'))) {
         $postprofessional = $this->input->post('professionalselect');
     }
     if (!empty($this->input->post('knowbyselect'))) {
         $postknowby = $this->input->post('knowbyselect');
     }
     $data['fromdate'] = $this->input->post('fromdate');
     $data['todate'] = $this->input->post('todate');
     $excelreport = $this->reportsmodel->fetchFeedbackDetails($data, $postdesignation, $postinterest, $postproduct, $postexperience, $postprofessional, $postknowby);
     // print_r($excelreport);
     // exit;
     //activate worksheet number 1
     $this->excel->setActiveSheetIndex(0);
     //name the worksheet
     $this->excel->getActiveSheet()->setTitle('Feedback Report');
     $this->excel->getActiveSheet()->getStyle('L3:L1000')->getNumberFormat()->setFormatCode('###0');
     $this->excel->getActiveSheet()->getStyle('G3:G1000')->getNumberFormat()->setFormatCode('###0');
     //save it to Excel5 format (excel 2003 .XLS file), change this to 'Excel2007' (and adjust the filename extension, also the header mime type)
     //if you want to save it as .XLSX Excel 2007 format
     $objWriter = PHPExcel_IOFactory::createWriter($this->excel, 'Excel5');
     $FontColor = new PHPExcel_Style_Color();
     $FontColor = new PHPExcel_Style_Color();
     $FontColor->setRGB("C5D6F2");
     $m = 'A';
     $p = 1;
     foreach ($excelreport as $exceldata) {
         foreach ($exceldata as $key => $value) {
             if ($p == 2) {
                 $this->excel->setActiveSheetIndex(0)->setCellValue($m . $p, $key);
                 $p = 3;
                 $this->excel->setActiveSheetIndex(0)->setCellValue($m . $p, $value);
                 $p = 2;
             } else {
                 if ($p == 1) {
                     $this->excel->setActiveSheetIndex(0)->setCellValue($m . $p, $key)->getStyle("C1:Z100")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
                 } else {
                     $this->excel->setActiveSheetIndex(0)->setCellValue($m . $p, $value);
                 }
             }
             $m++;
         }
         if ($p == 2) {
             $p = 4;
         } else {
             $p++;
         }
         $m = 'A';
     }
     $sheet = $this->excel->getActiveSheet();
     $lastColumn = $sheet->getHighestColumn();
     $lastColumn++;
     //$sheet->getColumnDimension('A')->setWidth(6);
     $sheet->getStyle('A1:' . $lastColumn . '2')->getFont()->setBold(true);
     for ($i = 'A'; $i != $lastColumn; $i++) {
         $sheet->getColumnDimension($i)->setAutoSize(true);
     }
     $this->excel->setActiveSheetIndex(0)->mergeCells('A1:D1');
     $objWriter = PHPExcel_IOFactory::createWriter($this->excel, 'Excel5');
     $chartid = 'Feedback Report';
     header("Content-type: application/vnd.ms-excel");
     header("Content-Disposition: attachment; filename=\"" . $chartid . ".xls\"");
     $objWriter->save('php://output');
 }
开发者ID:selva316，项目名称:trackingtool，代码行数:81，代码来源:reports.php

示例6: getIVal

 $activeSheet->getStyle("A{$count}")->getFont()->setBold(true);
 $activeSheet->getStyle("A{$count}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
 $activeSheet->getStyle("C{$count}")->getFont()->setBold(true)->setUnderline(PHPExcel_Style_Font::UNDERLINE_DOUBLEACCOUNTING);
 $activeSheet->getStyle("C{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4);
 $activeSheet->setCellValue("E{$count}", "Total");
 $activeSheet->setCellValue("G{$count}", "=SUM(G3:G" . ($count - 1) . ")");
 $activeSheet->getStyle("E{$count}")->getFont()->setBold(true);
 $activeSheet->getStyle("E{$count}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
 $activeSheet->getStyle("G{$count}")->getFont()->setBold(true)->setUnderline(PHPExcel_Style_Font::UNDERLINE_DOUBLEACCOUNTING);
 $activeSheet->getStyle("G{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4);
 $activeSheet->mergeCells("D2:D{$count}");
 $activeSheet->setCellValue("D2", "Year          " . getIVal("date_format(end_date, '%Y')", "sys_financial_year", "year_id = {$_GET['fyear']}"));
 $activeSheet->getStyle("D2")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER)->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER)->setTextRotation(90);
 $activeSheet->getStyle("D2")->getFont()->setBold(true)->setSize(24);
 $greyColor = new PHPExcel_Style_Color();
 $greyColor->setRGB("D9D9D9");
 $activeSheet->getStyle("A1")->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->setStartColor($greyColor);
 $activeSheet->getStyle("D2")->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->setStartColor($greyColor);
 $activeSheet->getStyle("A{$count}")->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->setStartColor($greyColor);
 $activeSheet->getStyle("B{$count}")->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->setStartColor($greyColor);
 $activeSheet->getStyle("C{$count}")->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->setStartColor($greyColor);
 $activeSheet->getStyle("E{$count}")->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->setStartColor($greyColor);
 $activeSheet->getStyle("F{$count}")->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->setStartColor($greyColor);
 $activeSheet->getStyle("G{$count}")->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->setStartColor($greyColor);
 $activeSheet->getStyle("A1:G{$count}")->applyFromArray($tableBorderArray);
 $objPHPExcel->setActiveSheetIndex(0);
 $fileName = "balance_sheet.xlsx";
 header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
 header('Content-Disposition: attachment;filename="' . $fileName . '"');
 header('Cache-Control: max-age=0');
 $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
开发者ID:kashifnasim，项目名称:nexexcel，代码行数:31，代码来源:balance_sheet.php

示例7: reporting

 public function reporting()
 {
     $this->load->library("excel");
     $q = isset($_GET['q']) ? $this->input->get('q', TRUE) : '';
     $data_filter = array();
     if (isset($_GET['siteid']) and !empty($_GET['siteid'])) {
         $data_filter['protelindo_site_id'] = $this->input->get('siteid', TRUE);
     }
     if (isset($_GET['region']) and !empty($_GET['region'])) {
         $data_filter['Region'] = $this->input->get('region', TRUE);
     }
     if (isset($_GET['status']) and !empty($_GET['status'])) {
         $data_filter['sla_event_status'] = $this->input->get('status', TRUE);
     }
     if (isset($_GET['desc']) and !empty($_GET['desc'])) {
         $data_filter['tt_status_description'] = $this->input->get('desc', TRUE);
     }
     if (isset($_GET['status_description']) and !empty($_GET['status_description'])) {
         $data_filter['tt_status_description'] = $this->input->get('status_description', TRUE);
     }
     if (isset($_GET['ttno']) and !empty($_GET['ttno'])) {
         $data_filter['tt_no'] = $this->input->get('ttno', TRUE);
     }
     //default tt open
     $data_filter['tt_open'] = $this->input->get('tt_open', TRUE);
     $result = $this->model_tt->reporting($data_filter);
     $this->excel->setActiveSheetIndex(0);
     $fields = $result->list_fields();
     $setting_dimension = array('A' => 30, 'B' => 25, 'C' => 25, 'D' => 25, 'E' => 25, 'F' => 25, 'G' => 25, 'H' => 25, 'I' => 25, 'J' => 25, 'K' => 25, 'L' => 25, 'M' => 25, 'N' => 25, 'O' => 25, 'P' => 25, 'Q' => 25, 'R' => 25, 'S' => 25, 'T' => 25, 'U' => 25, 'V' => 25, 'W' => 25, 'X' => 25, 'Y' => 25, 'Z' => 25, 'AA' => 25, 'AB' => 25, 'AC' => 25, 'AD' => 25, 'AE' => 25, 'AF' => 25, 'AG' => 25, 'AH' => 25);
     foreach ($setting_dimension as $col => $width) {
         $this->excel->getActiveSheet()->getColumnDimension($col)->setWidth($width);
     }
     $this->excel->getActiveSheet()->getStyle('A1:AH1')->applyFromArray(array('fill' => array('type' => PHPExcel_Style_Fill::FILL_SOLID, 'color' => array('rgb' => 'DA3232')), 'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER, 'vertical' => PHPExcel_Style_Alignment::VERTICAL_CENTER)));
     $phpColor = new PHPExcel_Style_Color();
     $phpColor->setRGB('FFFFFF');
     $this->excel->getActiveSheet()->getStyle('A1:AH1')->getFont()->setColor($phpColor);
     $this->excel->getActiveSheet()->getRowDimension(1)->setRowHeight(40);
     $this->excel->getActiveSheet()->getStyle('A1:AH1')->getAlignment()->setWrapText(true);
     $col = 0;
     foreach ($fields as $field) {
         $this->excel->getActiveSheet()->setCellValueByColumnAndRow($col, 1, $field);
         $col++;
     }
     $row = 2;
     foreach ($result->result() as $data) {
         $col = 0;
         foreach ($fields as $field) {
             if ($col == 19) {
                 $tno = 'TT Number';
                 $tt = $this->model_tt->get_single('tt', 'tt_no', $data->{$tno});
                 $activity = @$this->model_meta->get_meta_single('tt', $tt->idtt, 'tt_description', 'text')->meta_value;
                 $this->excel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $activity);
             } elseif ($col == 32) {
                 $st = 'TT Status';
                 $susName = 'Suspected Trouble Name';
                 $this->excel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, status_tt($data->{$st}, NULL, $data->{$susName}, NULL, FALSE, TRUE));
             } elseif ($col == 9) {
                 $eqtype = 'Equipment Type';
                 if ($data->{$eqtype} == '1') {
                     $type = 'Indoor';
                 } elseif ($data->{$eqtype} == '2') {
                     $type = 'Outdoor';
                 } elseif ($data->{$eqtype} == '3') {
                     $type = 'Base Only';
                 } elseif ($data->{$eqtype} == '4') {
                     $type = 'Outdoor 2';
                 } else {
                     $type = '-';
                 }
                 $this->excel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $type);
             } else {
                 $this->excel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $data->{$field});
             }
             $col++;
         }
         $row++;
     }
     //set border
     $styleArray = array('borders' => array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN)));
     $this->excel->getActiveSheet()->getStyle('A1:AH' . $row)->applyFromArray($styleArray);
     $this->excel->getActiveSheet()->setTitle('TT');
     header('Content-Type: application/vnd.ms-excel');
     header('Content-Disposition: attachment;filename=TT-Reporting-' . url_title(user_admin('username')) . '-' . date("Y-M-d") . '.xls');
     header('Cache-Control: max-age=0');
     header('Cache-Control: max-age=1');
     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: cache, must-revalidate');
     header('Pragma: public');
     $objWriter = PHPExcel_IOFactory::createWriter($this->excel, 'Excel5');
     $objWriter->save('php://output');
 }
开发者ID:ridwanskaterock，项目名称:coc-ri-comunnity，代码行数:92，代码来源:Tt.php

示例8: array

		/**
		 * Generates the sheet's workbook...
		 *
		 * @param String format extension
		 */
		function _generateSheets($format){


			$sheets= array();
			$sheets= $this->book->getSheets();
			$i= 0;


			if ($format=="ods"){

				foreach($sheets as $sheet){

					$cells= array();
					$cells= $sheet->getCells();


					foreach($cells as $cellarray){

						foreach($cellarray as $cell){

						$col= $cell->getDataColumn();
						$row= $cell->getDataRow();
						$data= $cell->getFormula();
						$fontId= $cell->getFontStyleId();
						$fontStyle= new FontStyle();
						$fontStyle= $this->book->getFontStyle($fontId);
						
						

						if (substr($data, 0, 1)== '=')

							$this->objPHPOds->addCell($i,$row,$col,substr($data, 1),'float');
							

						//TODO
						else /*OJO CON ESTO DISCERNIR ENTRE LOS DIFERENTES TIPOS*/

							$this->objPHPOds->addCell($i,$row,$col,$data,'string');

						}
						$this->objPHPOds->addStyle($fontStyle, $cell);
					}
					$i++;
				}
			}
			else{

				foreach($sheets as $sheet){

					if ($i>0)
						$this->objPHPExcel->createSheet();

					$this->objPHPExcel->setActiveSheetIndex($i);
					$j= $i + 1;
					$this->objPHPExcel->getActiveSheet()->setTitle("Sheet $j");

					$cells= array();
					
					$cells= $sheet->getCells();

					foreach($cells as $cellarray){

						$cell= new Cell();
						foreach ($cellarray as $cell){

						
							$col= $cell->getDataColumn();
							$row= $cell->getDataRow();
							$row++;
							
							$data= $cell->getFormula();
//							$this->objPHPExcel= new PHPExcel();
							
							
							$fontId= $cell->getFontStyleId();
							$fontStyle= new FontStyle();
							$fontStyle= $this->book->getFontStyle($fontId);
							$fontName= $fontStyle->getFontName();	
							$fcolor= substr($fontStyle->getFontColor(),1);
							
							if ($fcolor == "000000"){ 
								//echo "$row $col $fcolor<hr>";
							 	$ncolor= new PHPExcel_Style_Color(PHPExcel_Style_Color::COLOR_BLACK);
							 	$ncolor->setRGB($fcolor);							 	
							}
							else{
								//echo "$row $col $fcolor<hr>";
								$ncolor= new PHPExcel_Style_Color();
								$ncolor->setRGB($fcolor);				
							}	
							
							$style= new PHPExcel_Style();
							$style->getFont()->setColor($ncolor);
							$style->getFont()->setName($fontName);
							$style->getFont()->setBold($fontStyle->getFontBold()== 1);
//.........这里部分代码省略.........
开发者ID:Jtgadbois，项目名称:Pedadida，代码行数:101，代码来源:ExportController.class.php

示例9: reporting

 public function reporting()
 {
     $this->load->library("excel");
     $q = isset($_GET['q']) ? $_GET['q'] : '';
     $data_filter = array();
     if (isset($_GET['siteid']) and !empty($_GET['siteid'])) {
         $data_filter['pmp_idsite'] = $_GET['siteid'];
     }
     if (isset($_GET['region']) and !empty($_GET['region'])) {
         $data_filter['Region'] = $_GET['region'];
     }
     if (isset($_GET['priority']) and !empty($_GET['priority'])) {
         $data_filter['pmp_priority'] = $_GET['priority'];
     }
     if (isset($_GET['status']) and !empty($_GET['status'])) {
         $data_filter['pmp_status'] = $_GET['status'];
     }
     if (isset($_GET['period']) and !empty($_GET['period'])) {
         $data_filter['pm_period_idpm_period'] = (int) $_GET['period'];
     }
     if (isset($_GET['task_id']) and !empty($_GET['task_id'])) {
         $data_filter['idpm_plan_detil'] = (int) $_GET['task_id'];
     }
     if (isset($_GET['type']) and !empty($_GET['type'])) {
         $type = $_GET['type'];
         $idprotelqc = $this->input->get('idprotelqc');
         if ($type == 'allqc') {
             $data_filter['pmp_qc_protelindo'] = (int) $idprotelqc;
         } elseif ($type == 'qccompletion') {
             $data_filter['pmp_qc_protelindo'] = (int) $idprotelqc;
         } elseif ($type == 'qcwaitingapproval') {
             $data_filter['pmp_qc_protelindo'] = (int) $idprotelqc;
         }
     }
     $result = $this->model_task->reporting($data_filter);
     $this->excel->setActiveSheetIndex(0);
     $fields = $result->list_fields();
     $setting_dimension = array('A' => 40, 'B' => 25, 'C' => 25, 'D' => 25, 'E' => 25, 'F' => 25, 'G' => 25, 'H' => 25, 'I' => 25, 'J' => 25, 'K' => 25, 'L' => 25, 'M' => 25);
     foreach ($setting_dimension as $col => $width) {
         $this->excel->getActiveSheet()->getColumnDimension($col)->setWidth($width);
     }
     //styling
     $this->excel->getActiveSheet()->getStyle('A1:M1')->applyFromArray(array('fill' => array('type' => PHPExcel_Style_Fill::FILL_SOLID, 'color' => array('rgb' => 'DA3232')), 'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER, 'vertical' => PHPExcel_Style_Alignment::VERTICAL_CENTER)));
     $phpColor = new PHPExcel_Style_Color();
     $phpColor->setRGB('FFFFFF');
     $this->excel->getActiveSheet()->getStyle('A1:M1')->getFont()->setColor($phpColor);
     $this->excel->getActiveSheet()->getRowDimension(1)->setRowHeight(40);
     $this->excel->getActiveSheet()->getStyle('A1:M1')->getAlignment()->setWrapText(true);
     $col = 0;
     foreach ($fields as $field) {
         $this->excel->getActiveSheet()->setCellValueByColumnAndRow($col, 1, $field);
         $col++;
     }
     $row = 2;
     foreach ($result->result() as $data) {
         $col = 0;
         foreach ($fields as $field) {
             $this->excel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $data->{$field});
             $col++;
         }
         $row++;
     }
     //set border
     $styleArray = array('borders' => array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN)));
     $this->excel->getActiveSheet()->getStyle('A1:M' . $row)->applyFromArray($styleArray);
     $this->excel->getActiveSheet()->setTitle('TT');
     header('Content-Type: application/vnd.ms-excel');
     header('Content-Disposition: attachment;filename=PM-Reporting-' . url_title(user_admin('username')) . '-' . date("Y-M-d") . '.xls');
     header('Cache-Control: max-age=0');
     header('Cache-Control: max-age=1');
     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: cache, must-revalidate');
     header('Pragma: public');
     $objWriter = PHPExcel_IOFactory::createWriter($this->excel, 'Excel5');
     $objWriter->save('php://output');
 }
开发者ID:ridwanskaterock，项目名称:coc-ri-comunnity，代码行数:77，代码来源:Task.php


注：本文中的PHPExcel_Style_Color::setRGB方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。