Breaking News: Grepper is joining You.com. Read the official announcement!

phpspreadsheet setcellvalue row background color

Singh99 answered on March 28, 2022 Popularity 7/10 Helpfulness 10/10

answer phpspreadsheet setcellvalue row background color

phpspreadsheet setcellvalue row background color

Comment

$spreadsheet = new Spreadsheet();

$spreadsheet->getActiveSheet()->getStyle('A1:F1')->applyFromArray([
    'fill' => [
            'fillType' => Fill::FILL_SOLID,
            'startColor' => [
                'rgb' => 'FFDBE2F1',
            ]           
    ],
]);


Or for single row//

$spreadsheet = new Spreadsheet();
 $sheet = $spreadsheet->getActiveSheet();
 { inside Loop
 $sheet->setCellValue('A1', 'ID');
 $sheet->setCellValue('B1', 'Data di caricamento');
 $sheet->setCellValue('C1', 'Via');
 $sheet->setCellValue('D1', 'Municipio 
$sheet->getStyle("A$cellIndex:I$cellIndex")->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB($color);
          }// end loop here

Popularity 7/10 Helpfulness 10/10 Language php

Source: stackoverflow.com

Tags: background-color php phpspreadsheet row

Link to this answer
Share Copy Link

Contributed on Mar 28 2022

Singh99

0 Answers Avg Quality 2/10

phpspreadsheet setcellvalue row background color

Contents

More Related Answers

phpspreadsheet setcellvalue row background color

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.