How to Change color of a particular text using phpExcel by reading the text from the cell?

Asked Aug 27 '18 at 07:20

Active Aug 27 '18 at 07:28

Viewed 255 times

I have a text like Hello World in a cell. I want to change Color of the text World alone. I am using PHPExcel for creating excel.

I tried the below codes :

$objXls                 = new PHPExcel();
$objXls->getActiveSheet($sheetCount)->getStyle($cellCoordinates)->applyFromArray($styleArray);

The result of the above code is like whole text in the cell changed.

I tried PHPExcel_RichText also

       $objRichText = new PHPExcel_RichText();
       $objRichText->createText('World');
       $objPHPExcel->getActiveSheet()->getCell($cellCoordinates)->setValue($objRichText);

This also didn`t worked. Please help me to figure out the issue. Thanks

edited Aug 27 '18 at 07:28

Aneesh Jose

asked Aug 27 '18 at 07:20

User09111993

see this answer...it may help you https://stackoverflow.com/questions/48277293/set-different-font-color-inside-1-cell-using-phpexcel – Dr Manish Lataa-Manohar Joshi Aug 27 '18 at 07:24
I think createText() in PHPExcel_RichText won't work here – User09111993 Aug 27 '18 at 07:27
Possible duplicate of [PHPExcel - How to make part of the text bold](https://stackoverflow.com/questions/8045056/phpexcel-how-to-make-part-of-the-text-bold) – miken32 Aug 27 '18 at 22:01

How to Change color of a particular text using phpExcel by reading the text from the cell?

0 Answers0