getRowSettings

CONTENTS

LAYOUT AND SETTINGS

TEMPLATES

SAVE

FORMAT CONVERSION

transform

XLSXUTILITIES

INDEXER

indexer

PERFORMANCE

zipStream

CRYPTO

DIGITAL SIGNATURE

sign (XLSX)

getRowSettings

BASIC / ADVANCED / PREMIUM

Gets row settings.

Description

public getRowSettings($position)

This method returns an array with row settings.

Parameters

position

Row position in the active sheet: 1, 2... A1, B3...

Return values

Array with the row information. Null if the row position doesn't exist in the sheet.

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->addSheet(array('name'=> 'Other', 'removeSelected' => true, 'selected' => true, 'active' => true));

$content = array(
    'text' => 'Sed ut perspiciatis unde omnis',
);
$xlsx->addCell($content, 'A1');

// set row settings. The position is set using cell positions
$xlsx->setRowSettings('1', array('height' => 40));
$xlsx->setRowSettings('2', array('height' => 50));
$xlsx->setRowSettings('3', array('height' => 40));

// get row settings
$rowSettings = $xlsx->getRowSettings('1');
print_r($rowSettings);
$rowSettings = $xlsx->getRowSettings('2');
print_r($rowSettings);
$rowSettings = $xlsx->getRowSettings('3');
print_r($rowSettings);

Release notes

phpxlsx 3.0: new method.