xlswriter

Appearance

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 ​

php
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 ​

php
$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();