awsome-kill/php-spreadsheet-helper

created for easier and more efficiently import and export

v1.1 2019-10-18 10:20 UTC

Requires

• php: ^5.6|^7.0
• phpoffice/phpspreadsheet: ^1.6.0

MIT

• Lam

README

Created for easier import and export

Run Composer in your project:

  composer require awsome-kill/php-spreadsheet-helper

Export Key-value pair array

return SHelper::make('write')
    ->addTitle('XX商品列表')
    ->addHeader([
        ['name',20,'商品名称'],
        ['num',15,'数量'],
        ['category',20,'分类'],
        ['price',15,'售价']
    ])
    ->setData($data)
    ->output('商品表','xlsx');

Import into a specified key-value pair array

$list =  SHelper::make('read')
    ->addFile($file_path)
    ->setHeader([
        ['product_name','商品名称'],
        ['unit_name','单位'],
        ['category_name','商品分类'],
        ['price','价格'],
        ['cost_price','成本价'],
        ['bar_code','商品条码'],
        ['stock','库存']
    ])
    ->output();