Standard properties

Write standard document properties through the associative array passed to Excel::setProperties. All keys are optional; missing keys are not written.

Function Prototype

setProperties(array $properties): self

array $properties

Supported keys:

• title — title

• subject — subject

• author — author

• manager — manager

• company — company

• category — category

• keywords — keywords

• comments — comments

• status — status

• hyperlink_base — hyperlink base

• created — creation time, Unix timestamp (integer seconds). Defaults to the current time when omitted.

Example

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

$fileObject = new \Vtiful\Kernel\Excel($config);
$fileObject = $fileObject->fileName('tutorial.xlsx');

$filePath = $fileObject->header(['name', 'age'])
    ->data([
        ['viest', 21],
        ['wjx',   21]
    ])
    ->setProperties([
        'title'    => 'Q1 Report',
        'subject'  => 'Sales',
        'author'   => 'viest',
        'manager'  => 'wjx',
        'company'  => 'Vtiful',
        'category' => 'Finance',
        'keywords' => 'sales, q1, 2025',
        'comments' => 'Generated by xlswriter',
        'status'   => 'Draft',
        'created'  => time(),
    ])
    ->output();