exceler/example/BorderExample.php at master · ogenes/exceler · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
<?php

use Ogenes\Exceler\ExportClient;
use PhpOffice\PhpSpreadsheet\Style\Border;

require "vendor/autoload.php";

/**
 * User: ogenes <ogenes.yi@gmail.com>
 * Date: 2022/6/19
 */
class BorderExample
{
    /**
     * @throws \PhpOffice\PhpSpreadsheet\Exception
     * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
     */
    public function run(): string
    {
        $borders = [];
        $borders['bottom']['borderStyle'] = Border::BORDER_THIN;
        $borders['bottom']['color'] = ['argb' => 'F56C6C'];
//        仅对指定行的售价生效
//        $style['price']['borders'] = $borders;
        //对指定行所有字段生效
        $style['*']['borders'] = $borders;
        $data['sheet1'] = [
            ['goodsName' => '半裙', 'price' => 1490, 'actualStock' => 2,],
            ['goodsName' => '半裙', 'price' => 1590, 'actualStock' => 1 ]
        ];

        $config['sheet1'] = [
            ['bindKey' => 'goodsName', 'columnName' => '商品名称'],
            ['bindKey' => 'price', 'columnName' => '售价'],
            ['bindKey' => 'actualStock', 'columnName' => '实际库存'],
        ];
        $client = ExportClient::getInstance();
        $client->setStyleHeaderBorders($borders);
        $borders['bottom']['borderStyle'] = Border::BORDER_DASHDOT;
        $client->setStyleBorders($borders);

        return $client->setFilepath(__DIR__ . '/file/' . date('Y/m/d/'))
            ->setFilename('borderDemo' . date('His'))
            ->setData($data)
            ->setConfig($config)
            ->export();
    }
}


try {
    $filepath = (new BorderExample())->run();
    print_r($filepath);
} catch (\Exception $e) {
    print_r($e->getMessage());
}
echo PHP_EOL;