> For the complete documentation index, see [llms.txt](https://xlswriter-docs.viest.me/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://xlswriter-docs.viest.me/english/reader.md).

# Reader

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](https://xlswriter-docs.viest.me/english/reader/sheet_list.md), [worksheet list with metadata](https://xlswriter-docs.viest.me/english/reader/sheet-list-with-meta.md), [full read](https://xlswriter-docs.viest.me/english/reader/read-file-full.md), [cursor read](https://xlswriter-docs.viest.me/english/reader/read-file-cursor.md), [cell callback mode](https://xlswriter-docs.viest.me/english/reader/cell_callback.md)
* Filtering: [skip empty cells](https://xlswriter-docs.viest.me/english/reader/skip-empty-cells.md), [skip empty rows](https://xlswriter-docs.viest.me/english/reader/skip-empty-row.md), [set global type](https://xlswriter-docs.viest.me/english/reader/set-type.md), [read by data type](https://xlswriter-docs.viest.me/english/reader/data-type.md), [data type constants](https://xlswriter-docs.viest.me/english/reader/data-type-const.md)
* Cell-level: [next row with formula](https://xlswriter-docs.viest.me/english/reader/next-row-with-formula.md), [next row with rich text](https://xlswriter-docs.viest.me/english/reader/next-row-rich.md), [read style format](https://xlswriter-docs.viest.me/english/reader/get-style-format.md)
* Sheet-level metadata: [merged cells](https://xlswriter-docs.viest.me/english/reader/get-merged-cells.md), [hyperlinks](https://xlswriter-docs.viest.me/english/reader/get-hyperlinks.md), [sheet protection](https://xlswriter-docs.viest.me/english/reader/get-sheet-protection.md), [row / column options](https://xlswriter-docs.viest.me/english/reader/row-column-options.md), [conditional formats](https://xlswriter-docs.viest.me/english/reader/get-conditional-formats.md), [data validations](https://xlswriter-docs.viest.me/english/reader/get-data-validations.md), [auto filter](https://xlswriter-docs.viest.me/english/reader/get-auto-filter.md), [defined names](https://xlswriter-docs.viest.me/english/reader/get-defined-names.md), [page setup](https://xlswriter-docs.viest.me/english/reader/get-page-setup.md), [formula AST](https://xlswriter-docs.viest.me/english/reader/get-formula-ast.md)
* Embedded objects: [iterate images](https://xlswriter-docs.viest.me/english/reader/iterate-images.md), [iterate comments](https://xlswriter-docs.viest.me/english/reader/iterate-comments.md), [iterate charts](https://xlswriter-docs.viest.me/english/reader/iterate-charts.md)
