PHP-Xlswriter设置边框

        $config = [
            'path' => app()->getRootPath()."public/excel/" // xlsx文件保存路径
        ];
        $excel  = new \Vtiful\Kernel\Excel($config);
        $excel->fileName('tutorial.xlsx');
        $format        = new \Vtiful\Kernel\Format($excel->getHandle());
        $colorTwoStyle = $format
            ->fontColor(\Vtiful\Kernel\Format::COLOR_GREEN)
            ->toResource();
        $borderStyle = $format
            ->border(\Vtiful\Kernel\Format::BORDER_THIN)
            ->toResource();
        $filePath = $excel
            ->gridline(\Vtiful\Kernel\Excel::GRIDLINES_HIDE_ALL)
            ->defaultFormat($borderStyle)
            ->header(['hello', 'xlswriter'])
            ->defaultFormat($colorTwoStyle)
            ->data([
                ['hello', 'xlswriter'],
            ])
            ->setColumn('B:B', 25)
            ->output();

        $config = [
            'path' => '/www/wwwroot/swoole/erp-test-zhoao2/excel' // xlsx文件保存路径
        ];
        $excel  = new \Vtiful\Kernel\Excel($config);
        $excel->fileName('tutorial.xlsx');
        //边框
        $fileHandle = $excel->getHandle();
        $format  = new \Vtiful\Kernel\Format($fileHandle);
        $boldStyle = $format->bold()->toResource();
        $excel->mergeCells('A1:N1', '广东中奥物业管理有限公司');//合并单元格
        $excel->setRow('A1:A100', 20, $boldStyle);//单元格个高度
        $excel->insertText(3, 13, '打印时间'.date("Y-m-d H:i:s"));//在第4行第12列单元格插入
        //对齐居中
        $alignStyle = $format
            ->align(\Vtiful\Kernel\Format::FORMAT_ALIGN_CENTER, \Vtiful\Kernel\Format::FORMAT_ALIGN_VERTICAL_CENTER)
            ->toResource();
        $excel->setColumn('A1:N1', 10, $alignStyle);
        $excel->output();