james-ban/import-export

import excel or export excel

v1.51 2021-08-12 03:53 UTC

Requires

• php: >=7.2
• ext-json: *
• league/csv: ^9.5
• phpoffice/phpspreadsheet: ^1.9
• symfony/http-foundation: ^v5.0

BSD-4-Clause

• niupeiyuan

README

安装

composer require "james-ban/import-export"

使用

导入

<?php
require_once __DIR__ . '/vendor/autoload.php';

//过滤器
$filter = new class implements PhpOffice\PhpSpreadsheet\Reader\IReadFilter {
   public function readCell($column, $row, $worksheetName = ''):bool
   {
        return $column === 'A';
   }
};

$reader = new ImportExporter\import\Excel([
	'filePath' => '/Users/burn/Desktop/维权.xlsx',
	'fileExtension' => 'xlsx',
	'formatFunction' => function($item) {//只读取第一个单元格
		return current($item);
	},
	'fistLine' => 0,
	'readFilter' => $filter//读取A列
]);


print_r($reader->readAll());

导出 (csv/json/excel)

<?php
require_once __DIR__ . '/vendor/autoload.php';

//导出
$downloader = new ImportExporter\export\ExcelXml([
	'data' => [[1, '222'], [2, 'xxx']],
	'header' => ['id', 'name'],
	'filename' => 'test.xls',
]);
$downloader->download();