opensite/pexcel

excel library for php

1.0.0 2018-08-20 09:04 UTC

Requires

• phpoffice/phpspreadsheet: ^1.3

Requires (Dev)

• phpunit/phpunit: 6.0

MIT

README

Excel library for php

Requirement

1. PHP >= 5.6
2. Composer

Installation

$ composer require opensite/pexcel

Usage

<?php

use pexcel;


/**
 * 导出类型
 * 导出文件名
 * 重设默认配置
 */  
$excel = new Excel("xls","导出数据",$config);

// 发送单个sheet
/**
 * data array 导出单个sheet 的数据
 * $sheet string sheet工作表名称 默认为：sheet1
 */
$excel->export($data);

// 导出多个sheet
/**
 * $data string 为多维数组
 * $param $data:
 * [
 *  	[ //每个sheet对应的导出数据
 *			['name','age','test'],
 *			[''lucky',19,'test']
 *		],
 *		[
 *			['id','name','score'],
 *			[1,'lucky',90],
 *			[2,'nancy',99]
 *		]
 * ]
 * $sheets array 多个sheet时的工作表名称 默认为该类型默认sheet名
 */
$excel->exportSheet($data,$sheets);

Contributors

Your contributions are always welcome!

LICENSE

Released under MIT LICENSE