数字格式化

函数原型

number(string $format): self

string $format

数组格式字符串

"0.000"
"#,##0"
"#,##0.00"
"0.00"

示例

$config = [
    'path' => './tests'
];

$fileObject  = new \Vtiful\Kernel\Excel($config);

$fileObject = $fileObject->fileName('tutorial.xlsx');
$fileHandle = $fileObject->getHandle();

// 创建样式资源
$format      = new \Vtiful\Kernel\Format($fileHandle);
$numberStyle = $format->number('#,##0')->toResource();

$filePath = $fileObject->header(['name', 'balance'])
    ->data([
        ['viest', 10000],
        ['wjx',   100000]
    ])
    ->setColumn('B:B', 50, $numberStyle) // 应用样式
    ->output();

Last updated