README

包含基本功能的Excel电子表格，格式为(Office 2007+) xlsx

构建

使用

• ZipArchive，基于PHP的Zip扩展

支持

• 支持PHP 5.4+
• 支持简单公式
• 支持货币/日期/数字单元格格式化
• 接受UTF-8编码的输入
• 多工作表

开发

• PHPUnit
• 可选：PHP_CodeSniffer进行PSR-X兼容性检查

安装

安装此扩展的首选方法是通过composer。运行以下命令之一：

php composer.phar require --prefer-dist ellumilel/php-excel-writer

或添加

"ellumilel/php-excel-writer": ">=0.1.3"

到您的composer.json文件的require部分。

格式

• 'string' = 'GENERAL'
• 'text' = '@'
• 'integer' = '0'
• 'float_with_sep' = '#,##0.00'
• 'float' = '0.00'
• 'date' = 'YYYY-MM-DD'
• 'datetime' = 'YYYY-MM-DD HH:MM:SS'
• 'dollar' = '[$$-1009]#,##0.00;[RED]-[$$-1009]#,##0.00'
• 'money' = '[$$-1009]#,##0.00;[RED]-[$$-1009]#,##0.00'
• 'euro' = '#,##0.00 [$€-407];[RED]-#,##0.00 [$€-407]'
• 'rub' = '#,##0.00 [$₽-419];[Red]-#,##0.00 [$₽-419]'
• 'NN' = 'DDD'
• 'NNN' = 'DDDD'
• 'NNNN' = 'DDDD", "'

示例

简单

$header = [
    'test1' => 'YYYY-MM-DD HH:MM:SS',
    'test2' => 'string',
    'test3' => 'string',
    'test4' => 'string',
    'test5' => 'string',
    'test6' => 'money',
];

$wExcel = new Ellumilel\ExcelWriter();
$wExcel->writeSheetHeader('Sheet1', $header);
$wExcel->setAuthor('Your name here');
for ($i = 0; $i < 5000; $i++) {
    $wExcel->writeSheetRow('Sheet1', [
        (new DateTime())->format('Y-m-d H:i:s'),
        rand(100, 10000),
        rand(100, 10000),
        rand(100, 10000),
        rand(100, 10000),
        rand(100, 10000),
    ]);
}

$wExcel->writeToFile("example.xlsx");

3.200.000个单元格数据示例，低内存 ~0.84 mb，快速写入 ~120秒

$header = [
    'head1' => 'YYYY-MM-DD HH:MM:SS',
    'head2' => 'string',
    'head3' => 'string',
    'head4' => 'string',
    'head5' => 'string',
    'head6' => 'string',
    'head7' => 'string',
    'head8' => 'text',
];
$wExcel = new Ellumilel\ExcelWriter();
$wExcel->setAuthor('BigData Tester');
$wExcel->writeSheetHeader('Sheet1', $header);
for ($ex = 0; $ex < 400000; $ex++) {
    $wExcel->writeSheetRow('Sheet1', [
        (new DateTime())->format('Y-m-d H:i:s'),
        'foo',
        'baz',
        'your text hear',
        rand(10000, 100000),
        rand(10000, 100000),
        rand(10000, 100000),
        rand(10000, 100000),
    ]);
}
$wExcel->writeToFile("output_big_data.xlsx");

高级公式/格式

$header = [
    'created' => 'date',
    'id' => 'integer',
    'count' => '#,##0',
    'amount' => 'dollar',
    'description' => 'string',
    'money' => '[$$-1009]#,##0.00;[RED]-[$$-1009]#,##0.00',
    'sum' => 'dollar',
    'rub' => 'rub',
];
$data = [
    [
        '2016-01-01',
        123,
        1002,
        '103.00',
        'short string',
        '=D2*0.15',
        '=DOLLAR('.rand(10000, 100000).', 2)',
        rand(10000, 100000),
    ],
    [
        '2016-04-12',
        234,
        2045,
        '2.00',
        'loooooong string',
        '=D3*0.15',
        '=DOLLAR('.rand(10000, 100000).', 2)',
        rand(10000, 100000),
    ],
    [
        '2016-02-05',
        45,
        56,
        '56.00',
        'loooooong loooooong string',
        '=D4*0.15',
        '=DOLLAR('.rand(10000, 100000).', 2)',
        rand(10000, 100000),
    ],
    [
        '2016-06-27',
        534,
        107,
        '678.00',
        'loooooong loooooongloooooong string',
        '=D5*0.15',
        '=DOLLAR('.rand(10000, 100000).', 2)',
        rand(10000, 100000),
    ],
];

$wExcel = new Ellumilel\ExcelWriter();
$wExcel->writeSheet($data, 'Sheet1', $header);
$wExcel->writeToFile('formulas.xlsx');