indexer

CONTENTS

LAYOUT AND SETTINGS

TEMPLATES

SAVE

FORMAT CONVERSION

transform

XLSXUTILITIES

INDEXER

indexer

PERFORMANCE

zipStream

CRYPTO

DIGITAL SIGNATURE

sign (XLSX)

indexer

ADVANCED / PREMIUM

BASIC

Parses XLSX files and return information.

Description

Indexer(mixed $source)

This class parses the content of an XLSX file and returns an array with these contents:

comments
properties: core, custom
sheets: headers, footers, images, links, margins, sizes
signatures
styles: cell, table
tables
workbooks: sheets, workbookView, definedNames

Parameters

source

The path to the XLSX file to be parsed (Advanced and Premium licenses) or a XlsxStructure object (Premium licenses).

Return values

array

Code samples

Example #1:

require_once 'classes/CreateXlsx.php';

$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']);

Release notes

phpxlsx 3.0: table styles.
phpxlsx 2.5:

comments, defined names, cell positions and cell formats.
free DOMDocument resources.

phpxlsx 2.0: headers, footers and cell styles.
phpxlsx 1.0: new method.