setSheetSettings

Key	Type	Description
activeCell	string	Active cell.
color	string	HEX value.
marginTop	float	Measurement in inches.
marginRight	float	Measurement in inches.
marginBottom	float	Measurement in inches.
marginLeft	float	Measurement in inches.
marginHeader	float	Measurement in inches.
marginFooter	float	Measurement in inches.
orient	string	portrait, landscape.
paperType	string	A4, A3, letter, legal, A4-landscape, A3-landscape, letter-landscape, legal-landscape.
rtl	bool	Set to true for right to left.
state	string	hidden, visible.
tabSelected	bool	Tab selected.
view	string	View mode: normal, pageBreakPreview, pageLayout.

Code samples

Example #1

require_once 'classes/CreateXlsx.php';

$xlsx = new CreateXlsx();

$xlsx->setSheetSettings(array('paperType' => 'A4', 'marginTop' => 0.1, 'marginBottom' => 0.1));

$xlsx->saveXlsx('output');

The resulting XLSX looks like:

Release notes

phpxlsx 3.0: color option.
phpxlsx 2.0: state and view options.
phpxlsx 1.0: new method.