# 读取文件

读取功能可以打开已有 XLSX 文件，并通过两种方式访问数据：全量读取（一次性返回二维数组）或游标读取（逐行返回，内存恒定）。除了单元格内容外，还可以读取样式、合并单元格、超链接、数据验证、条件格式、页面设置、定义名称以及图片、批注、图表等元数据。

读取功能需要在编译扩展时启用 `--enable-reader`（PECL 包默认开启）。

本节内容：

* 迭代：[工作表列表](/zhong-wen-jian-ti/reader/sheet_list.md)、[工作表列表（含元数据）](/zhong-wen-jian-ti/reader/sheet-list-with-meta.md)、[全量读取](/zhong-wen-jian-ti/reader/read-file-full.md)、[游标读取](/zhong-wen-jian-ti/reader/read-file-cursor.md)、[单元格回调模式](/zhong-wen-jian-ti/reader/cell_callback.md)
* 过滤：[跳过指定行](/zhong-wen-jian-ti/reader/skip-rows.md)、[忽略空白单元格](/zhong-wen-jian-ti/reader/skip-empty-cells.md)、[忽略空白行](/zhong-wen-jian-ti/reader/skip-empty-row.md)、[跳过常量](/zhong-wen-jian-ti/reader/skip-const.md)、[设置全局读取类型](/zhong-wen-jian-ti/reader/set-type.md)、[按数据类型读取](/zhong-wen-jian-ti/reader/data-type.md)、[数据类型常量](/zhong-wen-jian-ti/reader/data-type-const.md)
* 单元格：[读取公式](/zhong-wen-jian-ti/reader/next-row-with-formula.md)、[读取富文本](/zhong-wen-jian-ti/reader/next-row-rich.md)、[读取样式](/zhong-wen-jian-ti/reader/get-style-format.md)
* 工作表元数据：[合并单元格](/zhong-wen-jian-ti/reader/get-merged-cells.md)、[超链接](/zhong-wen-jian-ti/reader/get-hyperlinks.md)、[工作表保护](/zhong-wen-jian-ti/reader/get-sheet-protection.md)、[行 / 列设置](/zhong-wen-jian-ti/reader/row-column-options.md)、[条件格式](/zhong-wen-jian-ti/reader/get-conditional-formats.md)、[数据验证](/zhong-wen-jian-ti/reader/get-data-validations.md)、[自动筛选](/zhong-wen-jian-ti/reader/get-auto-filter.md)、[定义名称](/zhong-wen-jian-ti/reader/get-defined-names.md)、[页面设置](/zhong-wen-jian-ti/reader/get-page-setup.md)、[公式 AST](/zhong-wen-jian-ti/reader/get-formula-ast.md)
* 嵌入对象：[遍历图片](/zhong-wen-jian-ti/reader/iterate-images.md)、[遍历批注](/zhong-wen-jian-ti/reader/iterate-comments.md)、[遍历图表](/zhong-wen-jian-ti/reader/iterate-charts.md)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://xlswriter-docs.viest.me/zhong-wen-jian-ti/reader.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.