# z-excel **Repository Path**: firezihai/z-excel ## Basic Information - **Project Name**: z-excel - **Description**: No description available - **Primary Language**: Unknown - **License**: GPL-3.0 - **Default Branch**: master - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 0 - **Forks**: 0 - **Created**: 2024-11-26 - **Last Updated**: 2025-04-27 ## Categories & Tags **Categories**: Uncategorized **Tags**: None ## README # Z-Excel ## 功能 - 用于解析和导出表格 - 支持phpoffice、xlswriter ## 安装 ```shell composer require firezihai/z-excel ``` ## 使用 ### 定义DTO ```php //index按表头索引解析表格,name:按表头名称解析表格,默认name #[ExcelDto(type:"index")] class UserDto implements ExcelDtoInterface { // 导出表格无index时,属性在类中的顺序,即为表头的顺序 #[ExcelHeader(name:"用户名",index:0)] public string $username; #[ExcelHeader(name:"昵称",index:1)] public string $nickname; #[ExcelHeader(name:"出生日期",index:3)] public string $birthday; #[ExcelHeader(name:"性别",index:2,formatter:true)] public string $gender; // 将性别转成中文 public function formatterGender($value) { $gender = ['未知','男','女']; return $gender[$value]??''; } } ``` ### 解析表格 ```php $excelFactory = new ExcelFactory(); $excel = $excelFactory->get('phpOffice'); $data = $excel->parse('./test.xlsx', UserDto::class); ``` > 注意 `xlswriter` 解析表格时,需安装 [xlswriter](https://github.com/viest/php-ext-xlswriter) 扩展