load($inputFileName); // Read an array list of any custom properties for this document $customPropertyList = $spreadsheet->getProperties()->getCustomProperties(); // Loop through the list of custom properties foreach ($customPropertyList as $customPropertyName) { $helper->log('' . $customPropertyName . ': '); // Retrieve the property value $propertyValue = $spreadsheet->getProperties()->getCustomPropertyValue($customPropertyName); // Retrieve the property type $propertyType = $spreadsheet->getProperties()->getCustomPropertyType($customPropertyName); // Manipulate properties as appropriate for display purposes switch ($propertyType) { case 'i': // integer $propertyType = 'integer number'; break; case 'f': // float $propertyType = 'floating point number'; break; case 's': // string $propertyType = 'string'; break; case 'd': // date $propertyValue = date('l, d<\s\up>S F Y g:i A', $propertyValue); $propertyType = 'date'; break; case 'b': // boolean $propertyValue = ($propertyValue) ? 'TRUE' : 'FALSE'; $propertyType = 'boolean'; break; } $helper->log($propertyValue . ' (' . $propertyType . ')'); }