【参考方案1】:
当您为 PhpSpreadsheet 指定 ARGB 时,您不必包含 # 符号。这些解决方案将能够将单元格背景设置为白色:
逐个单元格
s
p
r
e
a
d
s
h
e
e
t
−
>
g
e
t
A
c
t
i
v
e
S
h
e
e
t
(
)
−
>
g
e
t
S
t
y
l
e
(
spreadsheet ->getActiveSheet() ->getStyle(
spreadsheet−>getActiveSheet()−>getStyle(cells)
->getFill()
->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
->getStartColor()
->setARGB(‘ffffff’);
单元格范围
$spreadsheet
->getActiveSheet()
->getStyle(‘A1:A5’)
->getFill()
->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
->getStartColor()
->setARGB(‘ffffff’);
【讨论】:
【参考方案2】:
通过使用样式数组一次设置几个样式:
styleArray = array(
‘borders’ => array(
‘outline’ => array(
‘borderStyle’ => Border::BORDER_THICK,
‘color’ => array(‘argb’ => ‘00000000’),
),
),
‘fill’ => array(
‘fillType’ => Fill::FILL_SOLID,
‘startColor’ => array(‘argb’ => ‘FF4F81BD’)
)
);
s
p
r
e
a
d
s
h
e
e
t
−
>
g
e
t
A
c
t
i
v
e
S
h
e
e
t
(
)
−
>
a
p
p
l
y
F
r
o
m
A
r
r
a
y
(
spreadsheet->getActiveSheet()->applyFromArray(
spreadsheet−>getActiveSheet()−>applyFromArray(styleArray);