excel

composer require dashingUnique/excel

导出文件信息

use dashingUnique\excel\DashingExcel;
use app\model\User;
// Load users
$users = new User()->select();
$users = uniqueCollection($users);
// Export all users
(new DashingExcel($users))->export('file.csv');

$users = new User()->select();
$users = uniqueCollection($users);
(new DashingExcel($users))->export('users.csv', function ($user) {
 return [
 'Email' => $user['email'],
 'First Name' => $user['firstname'],
 'Last Name' => strtotime($user['create_time']),
 ];
});

导入文件信息

$collection = (new DashingExcel())->configureCsv(';', '#', '\n', 'gbk')->import('file.csv');

$users = (new DashingExcel())->import('file.xlsx', function ($line) {
 return (new User())->create([
 'name' => $line['Name'],
 'email' => $line['Email']
 ]);
});