for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
declare(strict_types=1);
namespace PhpOffice\PhpSpreadsheetTests\Worksheet;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PHPUnit\Framework\TestCase;
class ColumnRowStyleTest extends TestCase
{
public function testColumnStyle(): void
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$columnStyle = $sheet->getStyle('B:C');
$columnStyle->applyFromArray([
'font' => ['name' => 'Who knows'],
]);
self::assertSame(
'Who knows',
$sheet->getColumnStyle('B')?->getFont()->getName()
);
$sheet->getColumnStyle('C')?->getFont()->getName()
self::assertNull(
$sheet->getColumnStyle('A')?->getFont()->getName()
$sheet->getColumnStyle('D')?->getFont()->getName()
$spreadsheet->disconnectWorksheets();
}
public function testRowStyle(): void
$rowStyle = $sheet->getStyle('2:3');
$rowStyle->applyFromArray([
$sheet->getRowStyle(2)?->getFont()->getName()
$sheet->getRowStyle(3)?->getFont()->getName()
$sheet->getRowStyle(1)?->getFont()->getName()
$sheet->getRowStyle(4)?->getFont()->getName()