?? GreyFile

?? GreyFile — Mystic File Browser

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

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

?? Editing: 31_Document_properties_write.php

<?php

use PhpOffice\PhpSpreadsheet\Document\Properties;
use PhpOffice\PhpSpreadsheet\IOFactory;

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

$inputFileType = 'Xlsx';
$inputFileName = __DIR__ . '/../templates/31docproperties.xlsx';

$spreadsheetReader = IOFactory::createReader($inputFileType);
$callStartTime = microtime(true);
$spreadsheet = $spreadsheetReader->load($inputFileName);
$helper->logRead($inputFileType, $inputFileName, $callStartTime);

$helper->log('Adjust properties');
$spreadsheet->getProperties()->setTitle('Office 2007 XLSX Test Document')
    ->setSubject('Office 2007 XLSX Test Document')
    ->setDescription('Test XLSX document, generated using PhpSpreadsheet')
    ->setKeywords('office 2007 openxml php');

// Save Excel 2007 file
$filename = $helper->getFilename(__FILE__);
$writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
$callStartTime = microtime(true);
$writer->save($filename);
$helper->logWrite($writer, $filename, $callStartTime);

$helper->logEndingNotes();

// Reread File
$helper->log('Reread Xlsx file');
$spreadsheetRead = IOFactory::load($filename);

// Set properties
$helper->log('Get properties');

$helper->log('Core Properties:');
$helper->log('    Created by - ' . $spreadsheet->getProperties()->getCreator());
$helper->log('    Created on - ' . date('d-M-Y' . $spreadsheet->getProperties()->getCreated()) . ' at ' . date('H:i:s' . $spreadsheet->getProperties()->getCreated()));
$helper->log('    Last Modified by - ' . $spreadsheet->getProperties()->getLastModifiedBy());
$helper->log('    Last Modified on - ' . date('d-M-Y' . $spreadsheet->getProperties()->getModified()) . ' at ' . date('H:i:s' . $spreadsheet->getProperties()->getModified()));
$helper->log('    Title - ' . $spreadsheet->getProperties()->getTitle());
$helper->log('    Subject - ' . $spreadsheet->getProperties()->getSubject());
$helper->log('    Description - ' . $spreadsheet->getProperties()->getDescription());
$helper->log('    Keywords: - ' . $spreadsheet->getProperties()->getKeywords());

$helper->log('Extended (Application) Properties:');
$helper->log('    Category - ' . $spreadsheet->getProperties()->getCategory());
$helper->log('    Company - ' . $spreadsheet->getProperties()->getCompany());
$helper->log('    Manager - ' . $spreadsheet->getProperties()->getManager());

$helper->log('Custom Properties:');
$customProperties = $spreadsheet->getProperties()->getCustomProperties();
foreach ($customProperties as $customProperty) {
    $propertyValue = $spreadsheet->getProperties()->getCustomPropertyValue($customProperty);
    $propertyType = $spreadsheet->getProperties()->getCustomPropertyType($customProperty);
    if ($propertyType == Properties::PROPERTY_TYPE_DATE) {
        $formattedValue = date('d-M-Y H:i:s', (int) $propertyValue);
    } elseif ($propertyType == Properties::PROPERTY_TYPE_BOOLEAN) {
        $formattedValue = $propertyValue ? 'TRUE' : 'FALSE';
    } else {
        $formattedValue = $propertyValue;
    }
    $helper->log('    ' . $customProperty . ' - (' . $propertyType . ') - ' . $formattedValue);
}

$helper->logEndingNotes();

?? data | ??? Delete
?? 01_Simple.php | ?? Edit | ??? Delete
?? 01_Simple_download_ods.php | ?? Edit | ??? Delete
?? 01_Simple_download_pdf.php | ?? Edit | ??? Delete
?? 01_Simple_download_xls.php | ?? Edit | ??? Delete
?? 01_Simple_download_xlsx.php | ?? Edit | ??? Delete
?? 02_Types.php | ?? Edit | ??? Delete
?? 03_Formulas.php | ?? Edit | ??? Delete
?? 04_Printing.php | ?? Edit | ??? Delete
?? 05_Feature_demo.php | ?? Edit | ??? Delete
?? 06_Largescale.php | ?? Edit | ??? Delete
?? 07_Reader.php | ?? Edit | ??? Delete
?? 08_Conditional_formatting.php | ?? Edit | ??? Delete
?? 08_Conditional_formatting_2.php | ?? Edit | ??? Delete
?? 09_Pagebreaks.php | ?? Edit | ??? Delete
?? 11_Documentsecurity.php | ?? Edit | ??? Delete
?? 12_CellProtection.php | ?? Edit | ??? Delete
?? 13_Calculation.php | ?? Edit | ??? Delete
?? 13_CalculationCyclicFormulae.php | ?? Edit | ??? Delete
?? 14_Xls.php | ?? Edit | ??? Delete
?? 15_Datavalidation.php | ?? Edit | ??? Delete
?? 16_Csv.php | ?? Edit | ??? Delete
?? 17_Html.php | ?? Edit | ??? Delete
?? 18_Extendedcalculation.php | ?? Edit | ??? Delete
?? 19_Namedrange.php | ?? Edit | ??? Delete
?? 20_Read_Excel2003XML.php | ?? Edit | ??? Delete
?? 20_Read_Gnumeric.php | ?? Edit | ??? Delete
?? 20_Read_Ods.php | ?? Edit | ??? Delete
?? 20_Read_Sylk.php | ?? Edit | ??? Delete
?? 20_Read_Xls.php | ?? Edit | ??? Delete
?? 22_Heavily_formatted.php | ?? Edit | ??? Delete
?? 23_Sharedstyles.php | ?? Edit | ??? Delete
?? 24_Readfilter.php | ?? Edit | ??? Delete
?? 25_In_memory_image.php | ?? Edit | ??? Delete
?? 26_Utf8.php | ?? Edit | ??? Delete
?? 27_Images_Xls.php | ?? Edit | ??? Delete
?? 28_Iterator.php | ?? Edit | ??? Delete
?? 29_Advanced_value_binder.php | ?? Edit | ??? Delete
?? 30_Template.php | ?? Edit | ??? Delete
?? 31_Document_properties_write.php | ?? Edit | ??? Delete
?? 31_Document_properties_write_xls.php | ?? Edit | ??? Delete
?? 37_Page_layout_view.php | ?? Edit | ??? Delete
?? 38_Clone_worksheet.php | ?? Edit | ??? Delete
?? 39_Dropdown.php | ?? Edit | ??? Delete
?? 40_Duplicate_style.php | ?? Edit | ??? Delete
?? 41_Password.php | ?? Edit | ??? Delete
?? 42_RichText.php | ?? Edit | ??? Delete
?? 43_Merge_workbooks.php | ?? Edit | ??? Delete
?? 44_Worksheet_info.php | ?? Edit | ??? Delete
?? 45_Quadratic_equation_solver.php | ?? Edit | ??? Delete
?? 46_ReadHtml.php | ?? Edit | ??? Delete