addProperties

Key	Type	Description
title	string	The title of the spreadsheet.
subject	string	The subject of the spreadsheet.
creator	string	The spreadsheet author or creator.
keywords	string	A list of keywords that may be separated by any character you wish.
description	string	The description of the spreadsheet.
category	string	The category to which you want to associate the spreadsheet.
Manager	string	The name of the associated Manager.
Company	string	The company name.
created	string	The created date (W3CDTF without time zone).
modified	string	The modified date (W3CDTF without time zone).
lastModifiedBy	string	The username that modified the spreadsheet.
revision	string	The revision number.
custom	array	An array of custom properties. Each entry is composed by the name of the property as key and a value that is itself an array with the type and actual value of the variable.

Code samples

Example #1

require_once 'classes/CreateXlsx.php';

$xlsx = new CreateXlsx();

$properties = array(
    'title' => 'My title',
    'subject' => 'My subject',
    'creator' => 'The creator',
    'keywords' => 'keyword 1, keyword 2, keyword 3',
    'description' => 'The description could be much longer than this',
    'category' => 'My category',
    'contentStatus' => 'Draft',
    'Manager' => 'The boss',
    'Company' => 'My company',
    'custom' => array(
	    'My custom text' => array('text' => 'This is a reasonably large text'),
	    'My custom number' => array('number' => '4567'),
	    'My custom date' => array('date' => '1962-01-27T23:00:00Z'),
	    'My custom boolean' => array('boolean' => true)
	)
);
$xlsx->addProperties($properties);

$xlsx->saveXlsx('output');

The resulting XLSX looks like:

Release notes

phpxlsx 1.0: new method.