PHP code example of hesunfly / php-excel
1. Go to this page and download the library: Download hesunfly/php-excel library . Choose the download type require .
2. Extract the ZIP file and open the index.php.
3. Add this code to the index.php.
<?php
require_once('vendor/autoload.php');
/* Start to develop here. Best regards https://php-download.com/ */
hesunfly / php-excel example snippets
composer
// [名称, 字段名, 类型, 类型规则]
$header = [
['ID', 'id', 'text'],
['手机号码', 'mobile'], // 规则不填默认text
['openid', 'fans.openid', 'text'],
['昵称', 'fans.nickname', 'text'],
['关注/扫描', 'type', 'selectd', [1 => '关注', 2 => '扫描']],
['性别', 'sex', 'function', function($model){
return $model['sex'] == 1 ? '男' : '女';
}],
['创建时间', 'created_at', 'date', 'Y-m-d'],
['图片', 'image', 'text'],// 本地图片 ./images/765456898612.jpg
];
$list = [
[
'id' => 1,
'type' => 1,
'mobile' => '18888888888',
'fans' => [
'openid' => '123',
'nickname' => '昵称',
],
'sex' => 1,
'create_at' => time(),
]
];
/**
* 导入
*
* @param $filePath excel的服务器存放地址 可以取临时地址
* @param int $startRow 开始和行数 默认1
* @param bool $hasImg 导出的时候是否有图片
* @param string $suffix 格式
* @param string $imageFilePath 作为临时使用的 图片存放的地址
* @return array|bool|mixed
*/
$data = Excel::import($filePath, $startRow = 1,$hasImg = false,$suffix = 'Xlsx',$imageFilePath = null);