getCell

CONTENTS

LAYOUT AND SETTINGS

TEMPLATES

SAVE

FORMAT CONVERSION

transform

XLSXUTILITIES

INDEXER

indexer

PERFORMANCE

zipStream

CRYPTO

DIGITAL SIGNATURE

sign (XLSX)

getCell

BASIC / ADVANCED / PREMIUM

Gets information from a cell.

Description

public getCell($position)

This method returns an array with cell information.

Parameters

position

Cell position in the active sheet: A1, C3, AB7...

Return values

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

Code samples

Example #1

require_once 'classes/CreateXlsx.php';

$xlsx = new CreateXlsx();

// add contents as sample
$content = array(
    'text' => 'Lorem ipsum dolor sit amet',
);
$xlsx->addCell($content, 'A1');

$content = array(
    'text' => 100,
);
$xlsx->addCell($content, 'B1');
$content = array(
    'text' => 10.50,
);
$xlsx->addCell($content, 'B2');
$xlsx->addFunction('=SUM(B1:B2)', 'B3');

$content = array(
    'text' => 10.50,
);
$xlsx->addCell($content, 'C1');

// get cells information
var_dump($xlsx->getCell('A1'));

// return null because the position doesn't exist in the sheet
var_dump($xlsx->getCell('A2'));

// get cell information
var_dump($xlsx->getCell('B1'));

// get cell information
var_dump($xlsx->getCell('B3'));

// get cell information
var_dump($xlsx->getCell('C1'));

Release notes

phpxlsx 3.0: return numFmtId value.
phpxlsx 2.5: return style index value.
phpxlsx 1.0: new method.