indexer

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:

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.