k1low/xlsx

xlsx: PHPExcel wrapper

v0.4.0 2017-02-24 09:45 UTC

Requires

• php: >=5.4
• phpoffice/phpexcel: 1.8.*

Requires (Dev)

• fabpot/php-cs-fixer: *
• phpmd/phpmd: *
• phpunit/phpunit: <=5.6
• symfony/var-dumper: *
• thomasbachem/php-short-array-syntax-converter: dev-master

MIT

• Ken'ichiro Oyama

• excel

README

Usage

<?php
use Xlsx\Xlsx;

$xlsx = new Xlsx();
$xlsx->read('/path/to/template.xlsx')
    ->setValue('testvalue', [
        'col' => 'B',
        'row' => '10',
    ])
    ->setValue('testvalue_with_sheet', [
        'col' => 'B',
        'row' => '10',
        'sheet' => 2,
    ])
    ->setValue('testvalue_with_border', [
        'col' => 'C',
        'row' => '10',
        'border' => [
            'top' => PHPExcel_Style_Border::BORDER_THICK,
            'right' => PHPExcel_Style_Border::BORDER_MEDIUM,
            'left' => PHPExcel_Style_Border::BORDER_THIN,
            'bottom' => PHPExcel_Style_Border::BORDER_DOUBLE,
        ],
    ])
    ->setValue('testvalue_with_border', [
        'col' => 'E',
        'row' => '10',
        'border' => PHPExcel_Style_Border::BORDER_THICK,
    ])
    ->setValue('testvalue_with_color', [
        'col' => 'F',
        'row' => '10',
        'color' => PHPExcel_Style_Color::COLOR_BLUE,
    ])
    ->setValue('testvalue_with_backgroud_color', [
        'col' => 'G',
        'row' => '10',
        'backgroundColor' => PHPExcel_Style_Color::COLOR_YELLOW,
    ])
    ->write('/path/to/output.xlsx');