Skip to main content

​
Overview

The Style class is the main container for all cell styling in PhpSpreadsheet. It provides access to font, fill, borders, alignment, number format, and protection styling components.

​
Namespace

PhpOffice\PhpSpreadsheet\Style\Style

​
Getting a Style Object

// Get style for a single cell
$style = $spreadsheet->getActiveSheet()->getStyle('A1');

// Get style for a range of cells
$style = $spreadsheet->getActiveSheet()->getStyle('A1:D10');

​
Properties

The Style class contains the following style components:
​
font
Font
Font styling component
​
fill
Fill
Fill and background color component
​
borders
Borders
Border styling component
​
alignment
Alignment
Text alignment component
​
numberFormat
NumberFormat
Number formatting component
​
protection
Protection
Cell protection component

​
Methods

​
getFont()

Get the Font component. 
public function getFont(): Font
Example: 
$font = $spreadsheet->getActiveSheet()->getStyle('A1')->getFont();
$font->setBold(true);

​
getFill()

Get the Fill component. 
public function getFill(): Fill
Example: 
$fill = $spreadsheet->getActiveSheet()->getStyle('A1')->getFill();
$fill->setFillType(Fill::FILL_SOLID)
     ->getStartColor()->setARGB('FFFF0000');

​
getBorders()

Get the Borders component. 
public function getBorders(): Borders
Example: 
$borders = $spreadsheet->getActiveSheet()->getStyle('A1')->getBorders();
$borders->getTop()->setBorderStyle(Border::BORDER_THIN);

​
getAlignment()

Get the Alignment component. 
public function getAlignment(): Alignment
Example: 
$alignment = $spreadsheet->getActiveSheet()->getStyle('A1')->getAlignment();
$alignment->setHorizontal(Alignment::HORIZONTAL_CENTER);

​
getNumberFormat()

Get the NumberFormat component. 
public function getNumberFormat(): NumberFormat
Example: 
$numberFormat = $spreadsheet->getActiveSheet()->getStyle('A1')->getNumberFormat();
$numberFormat->setFormatCode(NumberFormat::FORMAT_CURRENCY_USD);

​
getProtection()

Get the Protection component. 
public function getProtection(): Protection

​
applyFromArray()

Apply multiple style settings at once using an array. 
public function applyFromArray(array $styleArray, bool $advancedBorders = true): static
​
styleArray
array
required
Array containing style information
​
advancedBorders
bool
default:"true"
Enable advanced border mode for ranges (supports allBorders, outline, inside)
Example: 
$spreadsheet->getActiveSheet()->getStyle('B2')->applyFromArray([
    'font' => [
        'name' => 'Arial',
        'bold' => true,
        'italic' => false,
        'underline' => Font::UNDERLINE_DOUBLE,
        'strikethrough' => false,
        'color' => [
            'rgb' => '808080'
        ]
    ],
    'borders' => [
        'bottom' => [
            'borderStyle' => Border::BORDER_DASHDOT,
            'color' => [
                'rgb' => '808080'
            ]
        ],
        'top' => [
            'borderStyle' => Border::BORDER_DASHDOT,
            'color' => [
                'rgb' => '808080'
            ]
        ]
    ],
    'alignment' => [
        'horizontal' => Alignment::HORIZONTAL_CENTER,
        'vertical' => Alignment::VERTICAL_CENTER,
        'wrapText' => true,
    ],
    'quotePrefix' => true
]);

​
Advanced Border Styling

When applying styles to a range with advancedBorders enabled, you can use special border properties: 
$spreadsheet->getActiveSheet()->getStyle('A1:D10')->applyFromArray([
    'borders' => [
        // Apply to all borders (outline + inside)
        'allBorders' => [
            'borderStyle' => Border::BORDER_THIN,
            'color' => ['rgb' => '000000']
        ],
        
        // Or apply to outline only
        'outline' => [
            'borderStyle' => Border::BORDER_THICK,
            'color' => ['rgb' => 'FF0000']
        ],
        
        // Or apply to inside borders
        'inside' => [
            'borderStyle' => Border::BORDER_THIN,
            'color' => ['rgb' => 'CCCCCC']
        ],
        
        // Vertical inside borders
        'vertical' => [
            'borderStyle' => Border::BORDER_THIN
        ],
        
        // Horizontal inside borders
        'horizontal' => [
            'borderStyle' => Border::BORDER_THIN
        ]
    ]
]);

​
getQuotePrefix()

Get the quote prefix setting. 
public function getQuotePrefix(): bool

​
setQuotePrefix()

Set the quote prefix (forces text interpretation in cell editor). 
public function setQuotePrefix(bool $quotePrefix): static
​
quotePrefix
bool
required
Whether to use quote prefix

​
getConditionalStyles()

Get conditional styles for the cell. 
public function getConditionalStyles(): array
Returns: Array of Conditional objects

​
setConditionalStyles()

Set conditional styles for the cell or range. 
public function setConditionalStyles(array $conditionalStyleArray): static
​
conditionalStyleArray
array
required
Array of Conditional style objects

​
Complete Example

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Style\Alignment;
use PhpOffice\PhpSpreadsheet\Style\Border;
use PhpOffice\PhpSpreadsheet\Style\Fill;
use PhpOffice\PhpSpreadsheet\Style\Font;
use PhpOffice\PhpSpreadsheet\Style\NumberFormat;

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();

// Set value
$sheet->setCellValue('A1', 'Styled Cell');

// Apply comprehensive styling
$sheet->getStyle('A1')->applyFromArray([
    'font' => [
        'name' => 'Arial',
        'size' => 14,
        'bold' => true,
        'italic' => true,
        'underline' => Font::UNDERLINE_SINGLE,
        'color' => ['rgb' => 'FFFFFF']
    ],
    'fill' => [
        'fillType' => Fill::FILL_SOLID,
        'startColor' => ['rgb' => '4472C4']
    ],
    'borders' => [
        'allBorders' => [
            'borderStyle' => Border::BORDER_THIN,
            'color' => ['rgb' => '000000']
        ]
    ],
    'alignment' => [
        'horizontal' => Alignment::HORIZONTAL_CENTER,
        'vertical' => Alignment::VERTICAL_CENTER,
        'wrapText' => true
    ],
    'numberFormat' => [
        'formatCode' => NumberFormat::FORMAT_CURRENCY_USD
    ]
]);

// Alternative: Use individual methods
$style = $sheet->getStyle('B2');
$style->getFont()
    ->setBold(true)
    ->setSize(12)
    ->getColor()->setRGB('FF0000');

$style->getFill()
    ->setFillType(Fill::FILL_SOLID)
    ->getStartColor()->setARGB('FFFFFF00');

$style->getBorders()->getAllBorders()
    ->setBorderStyle(Border::BORDER_MEDIUM)
    ->getColor()->setRGB('000000');

$style->getAlignment()
    ->setHorizontal(Alignment::HORIZONTAL_RIGHT)
    ->setVertical(Alignment::VERTICAL_TOP);

​
See Also

Build docs developers (and LLMs) love

Get started for freeTalk to us