README

方便导入和导出 excel.

安装

$ composer require k9606/kxcel

使用

• 导出

use K9606\Kxcel\Kxcel;

$sourceDatas = [
    [
        'id' => 1,
        'name' => '黄蜂女',
        'gender' => '女',
        'specialty' => '变化',
        'address' => '新泽西',
        'professional' => '复联成员',
    ],
    [
        'id' => 2,
        'name' => 'k9606',
        'gender' => '男',
        'specialty' => '无',
        'address' => '天府新区',
        'professional' => '复联成员',
    ],
    [
        'id' => 3,
        'name' => '蜘蛛侠',
        'gender' => '男',
        'specialty' => '灵敏',
        'address' => '皇后区',
        'professional' => '复联成员',
    ],
];

$sourceDataKeysAndColumnNames = [
    'name' => '姓名',
    'gender' => '性别',
    'address' => '所在地',
];

$fileName = 'excel';

$kxcel = new Kxcel();
$kxcel->export($sourceDatas, $sourceDataKeysAndColumnNames, $fileName);

请求:

响应:

• 导入

use K9606\Kxcel\Kxcel;

$filePath = './kxcel.xlsx';

$x = ['B' => 2];
$y = ['C' => 3];

$kxcel = new Kxcel();
$kxcel->import($filePath, $x, $y);

请求:

响应:

[
    [
        "女",
        "新泽西"
    ],
    [
        "男",
        "天府新区"
    ]
]

基于

PHPOffice/PhpSpreadsheet

overtrue/package-builder

License

MIT