createCellStyle

Preset style names: Bad, Calculation, Check Cell, Comma, Currency, Explanatory Text, Good, Heading 1, Heading 2, Heading 3, Heading 4, Input, Linked Cell, Neutral, Normal, Note, Output, Percent, Warning Text

styles

Key	Type	Description
backgroundColor	string	Hexadecimal color value: 'FFFF00', 'CCCCCC'...
bold	bool	If true the content will be shown in bold characters.
border	string	Border type: thin, thick, dashed, double, mediumDashDotDot, hair... This value can be overridden for each side with 'borderTop', 'borderRight', 'borderBottom', 'borderLeft' and 'borderDiagonal' properties.
borderColor	string	Hexadecimal color value: 'FFFF00', 'CCCCCC'... This value can be overridden for each side with 'borderColorTop', 'borderColorRight', 'borderColorBottom', 'borderColorLeft' and 'borderColorDiagonal' properties.
color	string	Hexadecimal color value: 'FF0000', '000000'...
font	string	Font family: 'Arial', 'Calibri'...
fontSize	int	Font size in points.
horizontalAlign	string	left, center, right.
indent	int	Indent value.
italic	bool	If true displays the content in italics.
locked	bool	Locked property.
rotation	int	Orientation degrees.
shrinkToFit	bool	If true enables shrink to fit.
strikethrough	bool	If true displays text in strikethrough.
subscript	bool	If true displays text in subscript.
superscript	bool	If true displays text in superscript.
textDirection	string	context, ltr, rtl.
typeOptions	array	Keys and values: formatCode (string)
underline	string	Underlines text: single, double.
verticalAlign	string	top, center, bottom.
wrapText	bool	If true enables wrap text.

options

Key	Type	Description
hidden	bool	Hidden attribute. Default as false.

Code samples

Example #1

require_once 'classes/CreateXlsx.php';

$xlsx = new CreateXlsx();

// create a custom cell style
$xlsx->createCellStyle('MyStyle1', array('bold' => true, 'fontSize' => 14, 'backgroundColor' => 'FFFF00'));

// add a new cell applying the custom cell style
$content = array(
    'text' => 'Lorem ipsum dolor sit amet',
);
$xlsx->addCell($content, 'A1', array('cellStyleName' => 'MyStyle1'));

// add a new cell applying a preset cell style
$content = array(
    'text' => 'Good',
);
$xlsx->addCell($content, 'B3', array('cellStyleName' => 'Good'));

$xlsx->saveXlsx('output');

The resulting XLSX looks like:

Release notes

phpxlsx 2.0: new method.