Available file properties

Properties that can be set with $excel->set{$property}()

Property name
creator
lastModifiedBy
title
description
subject
keywords
category
manager
company

Available sheet properties

Properties that can be set with $sheet->set{$property}()

Property name Possible value
orientation string
paperSize integer
scale integer
fitToPage boolean
fitToHeight boolean
fitToWidth boolean
columnsToRepeatAtLeft array
rowsToRepeatAtTop array
horizontalCentered boolean
verticalCentered boolean
printArea range
firstPageNumber integer

Available CSS styles

Styles that can be used inside an external CSS file or as inline CSS.

Style name Example Value
background(-color) #000000
color #FFFFFF
font-weight bold
font-style italic
font-weight bold
font-size 20px
font-family Open Sans
text-decoration underline
text-align center
vertical-align middle
border(-*) 1px dashed #CCC
width 100(px)
height 1100(px)

Available border styles

Style name PHPExcel class reference
none PHPExcel_Style_Border::BORDER_NONE
dashDot PHPExcel_Style_Border::BORDER_DASHDOT
dashDotDot PHPExcel_Style_Border::BORDER_DASHDOTDOT
dashed PHPExcel_Style_Border::BORDER_DASHED
dotted PHPExcel_Style_Border::BORDER_DOTTED
double PHPExcel_Style_Border::BORDER_DOUBLE
hair PHPExcel_Style_Border::BORDER_HAIR
medium PHPExcel_Style_Border::BORDER_MEDIUM
mediumDashDot PHPExcel_Style_Border::BORDER_MEDIUMDASHDOT
mediumDashDotDot PHPExcel_Style_Border::BORDER_MEDIUMDASHDOTDOT
mediumDashed PHPExcel_Style_Border::BORDER_MEDIUMDASHED
slantDashDot PHPExcel_Style_Border::BORDER_SLANTDASHDOT
thick PHPExcel_Style_Border::BORDER_THICK
thin PHPExcel_Style_Border::BORDER_THIN

Available column formatting

Format name PHPExcel class reference
General PHPExcel_Style_NumberFormat::FORMAT_GENERAL
@ PHPExcel_Style_NumberFormat::FORMAT_TEXT
0 PHPExcel_Style_NumberFormat::FORMAT_NUMBER
0.00 PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00
#,##0.00 PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1
#,##0.00_- PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED2
0% PHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE
0.00% PHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE_00
yyyy-mm-dd PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDD2
yy-mm-dd PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDD
dd/mm/yy PHPExcel_Style_NumberFormat::FORMAT_DATE_DDMMYYYY
d/m/y PHPExcel_Style_NumberFormat::FORMAT_DATE_DMYSLASH
d-m-y PHPExcel_Style_NumberFormat::FORMAT_DATE_DMYMINUS
d-m PHPExcel_Style_NumberFormat::FORMAT_DATE_DMMINUS
m-y PHPExcel_Style_NumberFormat::FORMAT_DATE_MYMINUS
mm-dd-yy PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX14
d-mmm-yy PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX15
d-mmm PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX16
mmm-yy PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX17
m/d/yy h:mm PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX22
d/m/y h:mm PHPExcel_Style_NumberFormat::FORMAT_DATE_DATETIME
h:mm AM/PM PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME1
h:mm:ss AM/PM PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME2
h:mm PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME3
h:mm:ss PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME4
mm:ss PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME5
h:mm:ss PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME6
i:s.S PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME7
h:mm:ss;@ PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME8
yy/mm/dd;@ PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDDSLASH
"$"#,##0.00_- PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_USD_SIMPLE
$#,##0_- PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_USD
[$EUR ]#,##0.00_- PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_EUR_SIMPLE

Closures

Method Closure class
create() Maatwebsite\Excel\Writers\LaravelExcelWriter
load() Maatwebsite\Excel\Readers\LaravelExcelReader
batch Maatwebsite\Excel\Readers\Batch
sheet() Maatwebsite\Excel\Classes\LaravelExcelWorksheet
cells() Maatwebsite\Excel\Writers\CellWriter
row() Maatwebsite\Excel\Writers\CellWriter