setRowSettings

CONTENTS

LAYOUT AND SETTINGS

TEMPLATES

SAVE

FORMAT CONVERSION

transform

XLSXUTILITIES

INDEXER

indexer

PERFORMANCE

zipStream

CRYPTO

DIGITAL SIGNATURE

sign (XLSX)

setRowSettings

BASIC / ADVANCED / PREMIUM

Sets row settings.

Description

public setRowSettings($position, $options = array())

This method sets row settings.

Parameters

position

Row position: 1, 2, 4...

options

Key	Type	Description
height	float	Row height.
hidden	bool	Hidden attribute.

Code samples

Example #1

require_once 'classes/CreateXlsx.php';

$xlsx = new CreateXlsx();

$content = array(
    'text' => 'Lorem ipsum dolor sit amet',
);
$xlsx->addCell($content, 'A2');

// set row settings. The position is set using row numbers
$xlsx->setRowSettings(4, array('height' => 90.25));
$xlsx->setRowSettings(2, array('height' => 60));
$xlsx->setRowSettings(3, array('height' => 50.25));

$xlsx->saveXlsx('output');

The resulting XLSX looks like:

Release notes

phpxlsx 2.0:
- state option.

phpxlsx 1.0:
- new method.