全局默认样式
设置全局默认样式,将会影响所有写入单元格的样式;
函数原型
defaultFormat(resource $formatHandler)
resource $formatHandler
单元格样式
示例
$config = ['path' => './tests'];
$excel = new \Vtiful\Kernel\Excel($config);
$excel->fileName('tutorial.xlsx');
$format = new \Vtiful\Kernel\Format($excel->getHandle());
$colorOneStyle = $format
->fontColor(\Vtiful\Kernel\Format::COLOR_ORANGE)
->border(\Vtiful\Kernel\Format::BORDER_DASH_DOT)
->toResource();
$format = new \Vtiful\Kernel\Format($excel->getHandle());
$colorTwoStyle = $format
->fontColor(\Vtiful\Kernel\Format::COLOR_GREEN)
->toResource();
$filePath = $excel
// Apply the first style as the default
->defaultFormat($colorOneStyle)
->header(['hello', 'xlswriter'])
// Apply the second style as the default style
->defaultFormat($colorTwoStyle)
->data([
['hello', 'xlswriter'],
])
->output();
Last updated