setColumnSettings

CONTENTS

LAYOUT AND SETTINGS

TEMPLATES

SAVE

FORMAT CONVERSION

transform

XLSXUTILITIES

INDEXER

indexer

PERFORMANCE

zipStream

CRYPTO

DIGITAL SIGNATURE

sign (XLSX)

setColumnSettings

BASIC / ADVANCED / PREMIUM

Sets column settings.

Description

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

This method sets column settings.

Parameters

position

Column position: A, B, C...

options

Key	Type	Description
hidden	bool	Hidden attribute.
width	float	Column width.

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->saveXlsx('output');

The resulting XLSX looks like:

Release notes

phpxlsx 2.0: state option.
phpxlsx 1.0: new method.