getCell

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

​x
 
1
require_once 'classes/CreateXlsx.php';
2
​
3
$xlsx = new CreateXlsx();
4
​
5
// add contents as sample
6
$content = array(
7
    'text' => 'Lorem ipsum dolor sit amet',
8
);
9
$xlsx->addCell($content, 'A1');
10
​
11
$content = array(
12
    'text' => 100,
13
);
14
$xlsx->addCell($content, 'B1');
15
$content = array(
16
    'text' => 10.50,
17
);
18
$xlsx->addCell($content, 'B2');
19
$xlsx->addFunction('=SUM(B1:B2)', 'B3');
20
​
21
$content = array(
22
    'text' => 10.50,
23
);
24
$xlsx->addCell($content, 'C1');
25
​
26
// get cells information
27
var_dump($xlsx->getCell('A1'));
28
​
29
// return null because the position doesn't exist in the sheet
30
var_dump($xlsx->getCell('A2'));
31
​
32
// get cell information
33
var_dump($xlsx->getCell('B1'));
34
​
35
// get cell information
36
var_dump($xlsx->getCell('B3'));
37
​
38
// get cell information
39
var_dump($xlsx->getCell('C1'));
40
​
Release notes
  • phpxlsx 4.5:
    • return cell styles.
  • phpxlsx 3.0:
    • return numFmtId value.
  • phpxlsx 2.5:
    • return style index value.
  • phpxlsx 1.0:
    • new method.
­
­