spreadsheet = $reader->load($filename); } public function testColours(): void { $colours = []; $worksheet = $this->spreadsheet->getActiveSheet(); for ($row = 1; $row <= 7; ++$row) { for ($column = 'A'; $column !== 'J'; ++$column) { $cellAddress = "{$column}{$row}"; $colours[$cellAddress] = $worksheet->getStyle($cellAddress)->getFill()->getStartColor()->getRGB(); } } $newSpreadsheet = $this->writeAndReload($this->spreadsheet, 'Xls'); $newWorksheet = $newSpreadsheet->getActiveSheet(); foreach ($colours as $cellAddress => $expectedColourValue) { $actualColourValue = $newWorksheet->getStyle($cellAddress)->getFill()->getStartColor()->getRGB(); self::assertSame($expectedColourValue, $actualColourValue); } } }