okcoder / php-excel
excel表格一键导入导出
v1.0.0
2018-12-25 08:49 UTC
Requires
- phpoffice/phpexcel: ^1.8
This package is auto-updated.
Last update: 2025-03-01 00:45:17 UTC
README
介绍
PHPExcel 封装 一键导入导出
安装教程
composer require okcoder/php-excel
使用说明
- 导入
$excel = new \OkCoder\PHPExcel\Main(); $ret = $excel->import('./15457201465c21d152642c53.90221892.xls', 0, [ 'A' => 'name', 'B' => 'age', 'C' => 'sex' ]); dd($ret);
2. 导出
name:名称
width:宽度
align:left、center、right、general、centerContinuous、justify、fill、distributed
$excel = new \OkCoder\PHPExcel\Main('Excel2007'); // excel5 excel2007 $ret1 = $excel->export([['name' => '姓名', 'width' => 60], ['name' => '年龄', 'align' => 'center'], '性别'], [
['OkCoder', 27, '男']
, ['OkCoder', 27, '男']
, ['OkCoder', 27, '男']
, ['OkCoder', 27, '男']
, ['OkCoder', 27, '男']
, ['OkCoder', 27, '男']
, ['OkCoder', 27, '男']
, ['OkCoder', 27, '男']
], true);
$ret2 = $excel->export(['姓名', '年龄', '性别'], [
['OkCoder', 27, '男']
, ['OkCoder', 27, '男']
, ['OkCoder', 27, '男']
, ['OkCoder', 27, '男']
, ['OkCoder', 27, '男']
, ['OkCoder', 27, '男']
, ['OkCoder', 27, '男']
, ['OkCoder', 27, '男']
], true);
dd($ret); // 返回保存文件名称($isDown=true时无效)
### 赞助二维码

