icarexm/excel

the new excel extend

dev-master 2020-05-26 14:00 UTC

This package is auto-updated.

Last update: 2024-03-26 22:02:07 UTC


README

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

composer require icarexm/excel:dev-master

从数据库中导出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);

实际效果:

导出多个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:

sheet2:

读取excel数据

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

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

$data就是读取后的数据