README

#Excel-Wroker V2.0

基于PHPExcel的一个简单的操作Excel的库。

##特性

支持多工作表

$worker->setSelectedSheets(['Sheet1', 'Sheet2'])->load('filename')->get();

指定列

$worker->load('filename', true)->get(['col1', 'col2']);
$worker->load('filename')->get([0, 1, 2]);

限制起始和结束行

//skip the first 5 rows.
$reader->skip(5)->get();
//only fetch 6 rows
$reader->take(6)->get();
//skip the first 7 rows and fetch the following 8 rows
$reader->skip(7)->take(8)->get();
//or
$reader->limit(7, 8)->get();

//attention
$reader->limit(-1, 8) // no skip
$reader->limit(7, -1) // no take

##安装

在您的 composer.json 中添加此包并更新composer。它也会为您下载PHPExcel。

"forehalo/excel-worker":"2.0.*"

##用法

在使用之前，您应该在文件中包含 vendor/autoload.php。

use ExcelWorker\ExcelWorker;
$worker = new ExcelWorker();

//Export
$rowNum = 2;
$writer = $worker->create('file'); //create() will return a Writer instance
$writer->writerRow(['a', 'b', 'c'], $rowNum);
$writer->writeColumn(['a', 'b', 'c'], $col); //both $col = 50 or $col = 'AX' could be accpeted.
$writer->save('xlsx');  //you may use ->save('xlsx', 'path') to specify the storage path.

//Import
//The second parameter is a bool value to tell whether header exists(probably the first row), default is false.
$worker->load('./path/filename.xlsx', true)->get();

//The load() method returns a Reader instance, so you could use as:
$reader = $worker->load('filename.xlsx');
$reader->get();

##许可证

https://gnu.ac.cn/licenses/lgpl.txt

forehalo / excel-worker

维护者

详细信息

README