PHPackages                             hzx/excel-dto - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [PDF & Document Generation](/categories/documents)
4. /
5. hzx/excel-dto

ActiveLibrary[PDF & Document Generation](/categories/documents)

hzx/excel-dto
=============

快速导出 excel 表格

v1.0.0(4y ago)27MITPHPPHP >=7.4

Since Sep 18Pushed 4y ago1 watchersCompare

[ Source](https://github.com/Wonghzx/excel-dto)[ Packagist](https://packagist.org/packages/hzx/excel-dto)[ RSS](/packages/hzx-excel-dto/feed)WikiDiscussions master Synced 5d ago

READMEChangelogDependencies (9)Versions (2)Used By (0)

hyperf excel-dto
================

[](#hyperf-excel-dto)

通过注解快速导出excel表格，默认使用 [xlswriter](https://xlswriter-docs.viest.me/) 进行表格处理

- PHP >= 7.4
- [xlswriter](https://xlswriter-docs.viest.me/) 扩展

1、安装
----

[](#1安装)

```
composer require hzx/excel-dto

```

2、使用
----

[](#2使用)

- 定义 Dto 数据对象
- @ExcelData 定义对象名称
- @ExcelProperty 定义属性

```
use Hzx\ExcelDto\Annotation\ExcelData;
use Hzx\ExcelDto\Annotation\ExcelProperty;

/**
 * @ExcelData(name="test")
 */
class Test
{

    /**
     * @ExcelProperty(value="用户名", index="0")
     */
    public $name;

    /**
     * @ExcelProperty(value="邮箱", index="1")
     */
    public $email;

    /**
     * @ExcelProperty(value="经度", index="3")
     */
    public $longitude;

    /**
     * @ExcelProperty(value="纬度", index="4")
     */
    public $latitude;
}
```

3、调用
----

[](#3调用)

@ExportExcel备注property对应 @ExcelData(name="test")path保存路径filename为空自动生成，（可填写为传参参数）```