Practical phpxlsx

Get information

Introduction

phpxlsx provides methods to get information from cell positions and XLSX files. These methods can be used combined with other methods of phpxlsx to generate flexible tasks based on the existing contents in a spreadsheet.

Cell information

The getCell method returns an array with cell content information such as its type and value:

public function getCell($position)

The following sample illustrates how to run this method:

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

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

The getCellPositions method returns all cell positions that include contents.

Indexer

Indexer parses the contents of an XLSX file and returns an array with information such as sheet names, properties, comments, links, images, table names and many other useful details about the spreadsheet.

The following sample code calls Indexer to get information from an XLSX file:

$indexer = new Indexer('file.xlsx');
$output = $indexer->getOutput();

print_r('sheets: ');
print_r($output['sheets']);

print_r('workbooks: ');
print_r($output['workbooks']);

print_r('comments: ');
print_r($output['comments']);

print_r('core properties: ');
print_r($output['properties']['core']);

print_r('custom properties: ');
print_r($output['properties']['custom']);

Tips and tricks

The getCell method returns null if the cell position doesn't exist in the sheet.

Next - Format transformations