$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();
![](https://i-blog.csdnimg.cn/blog_migrate/bc1c1ab6d8b0d0a3eef99b8abe42c5de.png)
$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();