PHPackages                             icarexm/excel - 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. icarexm/excel

ActiveLibrary

icarexm/excel
=============

the new excel extend

00PHP

Since May 26Pushed 5y ago1 watchersCompare

[ Source](https://github.com/icarexm/php-tools-excel)[ Packagist](https://packagist.org/packages/icarexm/excel)[ RSS](/packages/icarexm-excel/feed)WikiDiscussions master Synced 6d ago

READMEChangelogDependenciesVersions (1)Used By (0)

使用`Composer`安装`icarexm`的excel处理类库：

```
composer require icarexm/excel:dev-master

```

从数据库中导出excel数据
--------------

[](#从数据库中导出excel数据)

> 在导出数据前，请自己准备好数据，本文以写死数据作为示例，实际导出时需要通过数据库查询

我们在控制器中添加如下代码：

```
//需要导出的数据
$data = [
    ['nickname' => 'MrYe', 'age' => 18],
    ['nickname' => 'MrYe2', 'age' => 19],
    ['nickname' => 'MrYe3', 'age' => 20],
];
//和数据字段对应，在导出的表头中我们可以看到自定义的名称
$fields = [
    'nickname'  => '用户昵称',
    'age'       => '用户年龄',
];
//执行导出
$excelTool = new icarexm\excel\Excel();
$excelTool->export($data, $fields);

```

实际效果：

[![](https://camo.githubusercontent.com/02afd1d1f01d2a8f43f45153779ee0502e52585e94acd7220fce598c8f28990a/68747470733a2f2f696d672e6b616e636c6f75642e636e2f38382f36382f38383638366139383761353663363038333735353538643039646433393038355f333933783230312e706e67)](https://camo.githubusercontent.com/02afd1d1f01d2a8f43f45153779ee0502e52585e94acd7220fce598c8f28990a/68747470733a2f2f696d672e6b616e636c6f75642e636e2f38382f36382f38383638366139383761353663363038333735353538643039646433393038355f333933783230312e706e67)

导出多个sheet
---------

[](#导出多个sheet)

控制器中添加如下代码：

```
//需要导出的数据
$data = [
    [
        ['nickname' => 'MrYe', 'age' => 18],
        ['nickname' => 'MrYe2', 'age' => 19],
        ['nickname' => 'MrYe3', 'age' => 20],
    ],

    [
        ['nickname' => 'xin', 'sex' => '女'],
        ['nickname' => 'xin2', 'sex' => '女'],
        ['nickname' => 'xin3', 'sex' => '女'],
    ]
];
//和数据字段对应，在导出的表头中我们可以看到自定义的名称
$fields = [
        [
            'nickname'  => '用户昵称',
            'age'       => '用户年龄',
        ],
        [
            'nickname'  => '用户昵称',
            'sex'       => '用户性别',
        ],
];

$excelTool = new icarexm\excel\Excel();
$excelTool->export($data, $fields);

```

**sheet1：**

[![](https://camo.githubusercontent.com/e88247b8b43d62f8f324ef4b999c8950a560693daec9d625bc9aa3fa03bcf710/68747470733a2f2f696d672e6b616e636c6f75642e636e2f39382f33302f39383330353833366331656637626463623861326566636539633836653737335f353331783138342e706e67)](https://camo.githubusercontent.com/e88247b8b43d62f8f324ef4b999c8950a560693daec9d625bc9aa3fa03bcf710/68747470733a2f2f696d672e6b616e636c6f75642e636e2f39382f33302f39383330353833366331656637626463623861326566636539633836653737335f353331783138342e706e67)

**sheet2：**

[![](https://camo.githubusercontent.com/0b65d4ee081c9a33188470ad0f81e4ab69b15c77244b662058b993c80219545b/68747470733a2f2f696d672e6b616e636c6f75642e636e2f35632f39312f35633931306131656462373637323337323866613465383335313531353135395f353431783233342e706e67)](https://camo.githubusercontent.com/0b65d4ee081c9a33188470ad0f81e4ab69b15c77244b662058b993c80219545b/68747470733a2f2f696d672e6b616e636c6f75642e636e2f35632f39312f35633931306131656462373637323337323866613465383335313531353135395f353431783233342e706e67)

读取excel数据
---------

[](#读取excel数据)

我们在控制器中添加如下代码：

```
//读取的excel文件地址
$path = '数据.xlsx';
//读取数据
$excelTool = new icarexm\excel\Excel();
$data = $excelTool->read($path, 'all', true);

```

` $data`就是读取后的数据

###  Health Score

16

—

LowBetter than 5% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity0

Limited adoption so far

Community9

Small or concentrated contributor base

Maturity33

Early-stage or recently created project

 Bus Factor1

Top contributor holds 80% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

### Community

Maintainers

![](https://www.gravatar.com/avatar/a45259241de6b05216481510f09ae2978e5dc161ed01a0ce68bf2eb097ffb34f?d=identicon)[icarexm](/maintainers/icarexm)

---

Top Contributors

[![icarexm](https://avatars.githubusercontent.com/u/65947546?v=4)](https://github.com/icarexm "icarexm (4 commits)")[![mrye5869](https://avatars.githubusercontent.com/u/26958958?v=4)](https://github.com/mrye5869 "mrye5869 (1 commits)")

### Embed Badge

![Health badge](/badges/icarexm-excel/health.svg)

```
[![Health](https://phpackages.com/badges/icarexm-excel/health.svg)](https://phpackages.com/packages/icarexm-excel)
```

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)