getColumnSettings

CONTENTS

LAYOUT AND SETTINGS

TEMPLATES

SAVE

FORMAT CONVERSION

transform

XLSXUTILITIES

INDEXER

indexer

PERFORMANCE

zipStream

CRYPTO

DIGITAL SIGNATURE

sign (XLSX)

getColumnSettings

BASIC / ADVANCED / PREMIUM

Gets column settings.

Description

public getColumnSettings($position)

This method returns an array with column settings.

Parameters

position

Column position in the active sheet: A, B, C... A1, C3, AB7...

Return values

Array with the column information. Null if the column 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 column settings. The position is set using column letters
$xlsx->setColumnSettings('B', array('width' => 40));
$xlsx->setColumnSettings('C', array('width' => 30.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 column settings. The position is set using cell positions
$xlsx->setColumnSettings('A', array('width' => 20));
$xlsx->setColumnSettings('B', array('width' => 30));
$xlsx->setColumnSettings('C', array('width' => 25));

// get column settings
$columnSettings = $xlsx->getColumnSettings('A');
print_r($columnSettings);
$columnSettings = $xlsx->getColumnSettings('B');
print_r($columnSettings);
$columnSettings = $xlsx->getColumnSettings('C');
print_r($columnSettings);

Release notes

phpxlsx 3.0: new method.