> 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/zhong-wen-jian-ti/reader.md).

# 读取文件

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

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

本节内容：

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