Read file

The reader opens an existing XLSX and exposes its data either in full (load all rows into an array) or via a cursor (one row at a time, constant memory). It also surfaces sheet metadata — styles, merged cells, hyperlinks, validations, conditional formats, page setup, defined names, images, comments and charts.

Reader features require the extension to be built with --enable-reader (the default in PECL packages).

Pages in this section:

• Iteration: worksheet list, worksheet list with metadata, full read, cursor read, cell callback mode
• Filtering: skip rows, skip empty cells, skip empty rows, skip constants, set global type, read by data type, data type constants
• Cell-level: next row with formula, next row with rich text, read style format
• Sheet-level metadata: merged cells, hyperlinks, sheet protection, row / column options, conditional formats, data validations, auto filter, defined names, page setup, formula AST
• Embedded objects: iterate images, iterate comments, iterate charts