Change text background color for hyper link in PHPExcel

Question

In my PHPExcel library, I changed the color of hyper link using the below code

$link_style_array = array(
  'font'  => array(
    'color' => array('rgb' => '0000FF'),
    'underline' => 'single'
  )
);
$sheet->getStyle("A1")->applyFromArray($link_style_array);

And it works perfect. But the text have a background color like the below image

I would like to remove the background color or make it white.

Is there any way to do the same? Any help could be appreciated

http://stackoverflow.com/questions/6773272/set-background-cell-color-in-phpexcel — RJParikh, Jul 08 '16 at 12:05
@RuchishParikh, I am not looking for the cell background color. I need to change the grey text background color — Arun, Jul 08 '16 at 12:17

score 1 · Answer 1 · answered Jul 08 '16 at 12:06

here is the code for change cell color of phpExcel

$phpExcel = new PHPExcel();

$styleArray = array(
'font'  => array(
    'bold'  => false,
    'background-color' => array('rgb' => 'dadada'),
    'size'  => 12,
    'name'  => 'Arial'
));

$phpExcel->getActiveSheet()->getCell('B1')->setValue('Here your text');
$phpExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);

Change text background color for hyper link in PHPExcel

1 Answers1