Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col,$xlsRow,$plan);
- $objPHPExcel->getActiveSheet()->getStyle("A1")->getFill()
- ->setFillType(PHPExcel_Style_Fill::FILL_SOLID)
- ->getStartColor()->setRGB($color);
- $objPHPExcel->getActiveSheet()
- ->getStyle('A1:E1')
- ->getFill()
- ->setFillType(PHPExcel_Style_Fill::FILL_SOLID)
- ->getStartColor()
- ->setARGB('FF808080');
- $objPHPExcel->getActiveSheet()
- ->getStyle('A1:E1')
- ->applyFromArray(
- array(
- 'fill' => array(
- 'type' => PHPExcel_Style_Fill::FILL_SOLID,
- 'color' => array('rgb' => 'E05CC2')
- )
- )
- );
- $column = PHPExcel_Cell::stringFromColumnIndex(45);
- $row = 1;
- $cell = $column.$row;
- $objPHPExcel->getActiveSheet()->getStyle($range)->getFill()->applyFromArray(array(
- 'type' => PHPExcel_Style_Fill::FILL_SOLID,
- 'startcolor' => array(
- 'rgb' => 'FFFF00' //Yellow
- )
- ));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement