k1low/xlsx

xlsx: PHPExcel包装器

维护者

详细信息

github.com/k1LoW/xlsx

主页

源代码

问题

资助包维护！
k1LoW

安装数: 5,213

依赖项: 0

建议者: 0

安全性: 0

星标: 3

关注者: 3

分支: 3

开放问题: 1

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

Requires

Requires (Dev)

MIT cae3a8f80a32d090cacf76c4ed5140da1430623a

excel

This package is auto-updated.

Last update: 2024-09-06 09:27:54 UTC

README

用法

<?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');