# PHPExcel

**Repository Path**: okcoder/PHPExcel

## Basic Information

- **Project Name**: PHPExcel
- **Description**: excel表格一键导入导出
- **Primary Language**: PHP
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 5
- **Forks**: 2
- **Created**: 2018-12-25
- **Last Updated**: 2023-06-02

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# PHPExcel

#### 介绍
PHPExcel 封装 一键导入导出

#### 安装教程

```
composer require okcoder/php-excel

```

#### 使用说明

1. 导入
```
$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时无效)
```

### 赞助二维码

![微信打赏](https://images.gitee.com/uploads/images/2018/1228/122201_32d7aaa0_2159240.png "微信.png")
![支付宝打赏](https://images.gitee.com/uploads/images/2018/1228/122220_5d93117e_2159240.png "支付宝.png")