?? GreyFile

?? GreyFile — Mystic File Browser

Current path: home/webdevt/prestashop17/vendor/phpoffice/phpspreadsheet/samples/Reading_workbook_data/

?? Go up: /home/webdevt/prestashop17/vendor/phpoffice/phpspreadsheet/samples

?? Editing: Properties.php

<?php

use PhpOffice\PhpSpreadsheet\IOFactory;

require __DIR__ . '/../Header.php';

$inputFileType = 'Xls';
$inputFileName = __DIR__ . '/sampleData/example1.xls';

// Create a new Reader of the type defined in $inputFileType
$reader = IOFactory::createReader($inputFileType);
// Load $inputFileName to a PhpSpreadsheet Object
$spreadsheet = $reader->load($inputFileName);

// Read the document's creator property
$creator = $spreadsheet->getProperties()->getCreator();
$helper->log('Document Creator: ' . $creator);

// Read the Date when the workbook was created (as a PHP timestamp value)
$creationDatestamp = $spreadsheet->getProperties()->getCreated();
// Format the date and time using the standard PHP date() function
$creationDate = date('l, d<\s\up>S</\s\up> F Y', $creationDatestamp);
$creationTime = date('g:i A', $creationDatestamp);
$helper->log('Created On: ' . $creationDate . ' at ' . $creationTime);

// Read the name of the last person to modify this workbook
$modifiedBy = $spreadsheet->getProperties()->getLastModifiedBy();
$helper->log('Last Modified By: ' . $modifiedBy);

// Read the Date when the workbook was last modified (as a PHP timestamp value)
$modifiedDatestamp = $spreadsheet->getProperties()->getModified();
// Format the date and time using the standard PHP date() function
$modifiedDate = date('l, d<\s\up>S</\s\up> F Y', $modifiedDatestamp);
$modifiedTime = date('g:i A', $modifiedDatestamp);
$helper->log('Last Modified On: ' . $modifiedDate . ' at ' . $modifiedTime);

// Read the workbook title property
$workbookTitle = $spreadsheet->getProperties()->getTitle();
$helper->log('Title: ' . $workbookTitle);

// Read the workbook description property
$description = $spreadsheet->getProperties()->getDescription();
$helper->log('Description: ' . $description);

// Read the workbook subject property
$subject = $spreadsheet->getProperties()->getSubject();
$helper->log('Subject: ' . $subject);

// Read the workbook keywords property
$keywords = $spreadsheet->getProperties()->getKeywords();
$helper->log('Keywords: ' . $keywords);

// Read the workbook category property
$category = $spreadsheet->getProperties()->getCategory();
$helper->log('Category: ' . $category);

// Read the workbook company property
$company = $spreadsheet->getProperties()->getCompany();
$helper->log('Company: ' . $company);

// Read the workbook manager property
$manager = $spreadsheet->getProperties()->getManager();
$helper->log('Manager: ' . $manager);
$s = new \PhpOffice\PhpSpreadsheet\Helper\Sample();

?? sampleData | ??? Delete
?? Custom_properties.php | ?? Edit | ??? Delete
?? Custom_property_names.php | ?? Edit | ??? Delete
?? Properties.php | ?? Edit | ??? Delete
?? Worksheet_count_and_names.php | ?? Edit | ??? Delete