heyaender/excelintar-reader

Excelintar 读取器

维护者

详细信息

github.com/heyaender/excelintar-reader

源代码

问题

安装: 9

依赖: 2

建议: 0

安全: 0

星标: 0

关注者: 1

分支: 0

开放问题: 0

v1.0.0 2024-01-16 18:28 UTC

Requires

Requires (Dev)

MIT af24126955bff6a9028c258160089320e28ac65d

This package is auto-updated.

Last update: 2024-09-25 05:29:24 UTC

README

Excelintar 读取器（导入 Excel）文档

如何安装

composer require heyaender/excelintar-reader

如何使用

$sheet = $excel->getSheet('Articles');
$sheet->setReadArea('B5');
foreach ($sheet->nextRow() as $rowNum => $rowData) {
    $user = User::create([
        'name' => $rowData['B'],
        'birthday' => new \Carbon($rowData['C']),
        'password' => bcrypt($rowData['D']),
    ]);
    Article::create([
        'user_id' => $user->id,
        'title' => $rowData['E'],
        'date' => new \Carbon($rowData['F']),
        'public' => $rowData['G'] === 'yes',
    ]);
}
示例 Excel 导入
image