Advertisement
Guest User

Untitled

a guest
Aug 23rd, 2017
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col,$xlsRow,$plan);
  2.  
  3. $objPHPExcel->getActiveSheet()->getStyle("A1")->getFill()
  4. ->setFillType(PHPExcel_Style_Fill::FILL_SOLID)
  5. ->getStartColor()->setRGB($color);
  6.  
  7. $objPHPExcel->getActiveSheet()
  8. ->getStyle('A1:E1')
  9. ->getFill()
  10. ->setFillType(PHPExcel_Style_Fill::FILL_SOLID)
  11. ->getStartColor()
  12. ->setARGB('FF808080');
  13.  
  14. $objPHPExcel->getActiveSheet()
  15. ->getStyle('A1:E1')
  16. ->applyFromArray(
  17. array(
  18. 'fill' => array(
  19. 'type' => PHPExcel_Style_Fill::FILL_SOLID,
  20. 'color' => array('rgb' => 'E05CC2')
  21. )
  22. )
  23. );
  24.  
  25. $column = PHPExcel_Cell::stringFromColumnIndex(45);
  26. $row = 1;
  27. $cell = $column.$row;
  28.  
  29. $objPHPExcel->getActiveSheet()->getStyle($range)->getFill()->applyFromArray(array(
  30. 'type' => PHPExcel_Style_Fill::FILL_SOLID,
  31. 'startcolor' => array(
  32. 'rgb' => 'FFFF00' //Yellow
  33. )
  34. ));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement