Set Background cell color in PHPExcel

Question

How to set specific color to active cell when creating XLS document in PHPExcel

User · Answer

This always running    sheet- gt getActiveSheet  - gt getStyle  A1  - gt getFill  - gt getStartColor  - gt setRGB  FF0000

User · Answer

Here is how you do it in PHPSpreadsheet  the newest version of PHPExcel   spreadsheet   new Spreadsheet      spreadsheet- gt getActiveSheet  - gt getStyle  A1 F1  - gt applyFromArray        fill    gt                 fillType    gt  Fill  FILL SOLID               startColor    gt                     argb    gt   FFDBE2F1                                         alternative approach    spreadsheet- gt getActiveSheet       - gt getStyle  A1 F1       - gt getFill       - gt setFillType Fill  FILL SOLID      - gt getStartColor  - gt setARGB  FFDBE2F1

User · Answer

You can easily apply colours on cell and rows    sheet- gt cell 1  function  row         row- gt setBackground   CCCCCC           sheet- gt row 1    Col 1    Col 2    Col 3       sheet- gt row 1  function  row         row- gt setBackground   CCCCCC

User · Answer

Seems like there s a bug with applyFromArray right now that won t accept color  but this worked for me    objPHPExcel     - gt getActiveSheet       - gt getStyle  A1       - gt getFill       - gt getStartColor       - gt setRGB  FF0000

User · Answer

function cellColor  cells  color       global  objPHPExcel        objPHPExcel- gt getActiveSheet  - gt getStyle  cells - gt getFill  - gt applyFromArray array           type    gt  PHPExcel Style Fill  FILL SOLID           startcolor    gt  array                rgb    gt   color                      cellColor  B5    F28A8C    cellColor  G5    F28A8C    cellColor  A7 I7    F28A8C    cellColor  A17 I17    F28A8C    cellColor  A30 Z30    F28A8C

User · Answer

objPHPExcel     - gt getActiveSheet       - gt getStyle  A1       - gt getFill       - gt getStartColor       - gt getRGB

User · Answer

This code should work for you     PHPExcel- gt getActiveSheet           - gt getStyle  A1           - gt getFill           - gt setFillType PHPExcel Style Fill  FILL SOLID          - gt getStartColor           - gt setRGB  FF0000     But if you bother using this over and over again  I recommend using applyFromArray

User · Answer

sheet- gt getStyle  A1  - gt applyFromArray      array           fill    gt  array               type    gt  PHPExcel Style Fill  FILL SOLID               color    gt  array  rgb    gt   FF0000                        Source  http   bayu freelancer web id 2010 07 16 phpexcel-advanced-read-write-excel-made-simple

User · Answer

objPHPExcel - gt getActiveSheet   - gt getStyle  A1   - gt getFill   - gt setFillType PHPExcel Style Fill  FILL SOLID  - gt getStartColor   - gt setRGB  colorcode      i e colorcode D3D3D3

User · Answer

objPHPExcel- gt getActiveSheet  - gt getStyle  B3 B7  - gt getFill   - gt setFillType PHPExcel Style Fill  FILL SOLID  - gt getStartColor  - gt setARGB  FFFF0000      It s in the documentation  located here  https   github com PHPOffice PHPExcel wiki User-Documentation-Overview-and-Quickstart-Guide

[phpexcel] Set Background cell color in PHPExcel

Examples related to phpexcel