HEX
Server: Microsoft-IIS/8.5
System: Windows NT YDAWBH120 6.3 build 9600 (Windows Server 2012 R2 Standard Edition) AMD64
User: tentjecom_web (0)
PHP: 7.4.14
Disabled: NONE
Upload Files
File: D:/HostingSpaces/SBogers10/topswtw.komma.pro/vendor/maatwebsite/excel/docs/export/sheet-styling.md
# Sheet styling

### General styling

If you want to change the general styling of your sheet (not cell or range specific), you can use the `->setStyle()` method.

    // Set font with ->setStyle()`
    $sheet->setStyle(array(
        'font' => array(
            'name'      =>  'Calibri',
            'size'      =>  15,
            'bold'      =>  true
        )
    ));

### Fonts

To change the font for the current sheet use `->setFont($array)`:

    $sheet->setFont(array(
        'family'     => 'Calibri',
        'size'       => '15',
        'bold'       => true
    ));

#### Separate setters

    // Font family
    $sheet->setFontFamily('Comic Sans MS');

    // Font size
    $sheet->setFontSize(15);

    // Font bold
    $sheet->setFontBold(true);

### Borders

You can set borders for the sheet, by using:

    // Sets all borders
    $sheet->setAllBorders('thin');

    // Set border for cells
    $sheet->setBorder('A1', 'thin');

    // Set border for range
    $sheet->setBorder('A1:F10', 'thin');

> Go to the reference guide to see a list of available border styles