File Manager

✏️ Edit File: /home/rsukartini.com/rs/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx/Metadata.php

<?php

namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx;

use PhpOffice\PhpSpreadsheet\Reader\Xlsx\Namespaces;
use PhpOffice\PhpSpreadsheet\Shared\XMLWriter;

class Metadata extends WriterPart
{
    /**
     * Write content types to XML format.
     *
     * @return string XML Output
     */
    public function writeMetadata(): string
    {
        if (!$this->getParentWriter()->useDynamicArrays()) {
            return '';
        }
        // Create XML writer
        $objWriter = null;
        if ($this->getParentWriter()->getUseDiskCaching()) {
            $objWriter = new XMLWriter(XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());
        } else {
            $objWriter = new XMLWriter(XMLWriter::STORAGE_MEMORY);
        }

// XML header
        $objWriter->startDocument('1.0', 'UTF-8', 'yes');

// Types
        $objWriter->startElement('metadata');
        $objWriter->writeAttribute('xmlns', Namespaces::MAIN);
        $objWriter->writeAttribute('xmlns:xlrd', Namespaces::DYNAMIC_ARRAY_RICHDATA);
        $objWriter->writeAttribute('xmlns:xda', Namespaces::DYNAMIC_ARRAY);

$objWriter->startElement('metadataTypes');
        $objWriter->writeAttribute('count', '2');

$objWriter->startElement('metadataType');
        $objWriter->writeAttribute('name', 'XLDAPR');
        $objWriter->writeAttribute('minSupportedVersion', '120000');
        $objWriter->writeAttribute('copy', '1');
        $objWriter->writeAttribute('pasteAll', '1');
        $objWriter->writeAttribute('pasteValues', '1');
        $objWriter->writeAttribute('merge', '1');
        $objWriter->writeAttribute('splitFirst', '1');
        $objWriter->writeAttribute('rowColShift', '1');
        $objWriter->writeAttribute('clearFormats', '1');
        $objWriter->writeAttribute('clearComments', '1');
        $objWriter->writeAttribute('assign', '1');
        $objWriter->writeAttribute('coerce', '1');
        $objWriter->writeAttribute('cellMeta', '1');
        $objWriter->endElement(); // metadataType XLDAPR

$objWriter->startElement('metadataType');
        $objWriter->writeAttribute('name', 'XLRICHVALUE');
        $objWriter->writeAttribute('minSupportedVersion', '120000');
        $objWriter->writeAttribute('copy', '1');
        $objWriter->writeAttribute('pasteAll', '1');
        $objWriter->writeAttribute('pasteValues', '1');
        $objWriter->writeAttribute('merge', '1');
        $objWriter->writeAttribute('splitFirst', '1');
        $objWriter->writeAttribute('rowColShift', '1');
        $objWriter->writeAttribute('clearFormats', '1');
        $objWriter->writeAttribute('clearComments', '1');
        $objWriter->writeAttribute('assign', '1');
        $objWriter->writeAttribute('coerce', '1');
        $objWriter->endElement(); // metadataType XLRICHVALUE

$objWriter->endElement(); // metadataTypes

$objWriter->startElement('futureMetadata');
        $objWriter->writeAttribute('name', 'XLDAPR');
        $objWriter->writeAttribute('count', '1');
        $objWriter->startElement('bk');
        $objWriter->startElement('extLst');
        $objWriter->startElement('ext');
        $objWriter->writeAttribute('uri', '{bdbb8cdc-fa1e-496e-a857-3c3f30c029c3}');
        $objWriter->startElement('xda:dynamicArrayProperties');
        $objWriter->writeAttribute('fDynamic', '1');
        $objWriter->writeAttribute('fCollapsed', '0');
        $objWriter->endElement(); // xda:dynamicArrayProperties
        $objWriter->endElement(); // ext
        $objWriter->endElement(); // extLst
        $objWriter->endElement(); // bk
        $objWriter->endElement(); // futureMetadata XLDAPR

$objWriter->startElement('futureMetadata');
        $objWriter->writeAttribute('name', 'XLRICHVALUE');
        $objWriter->writeAttribute('count', '1');
        $objWriter->startElement('bk');
        $objWriter->startElement('extLst');
        $objWriter->startElement('ext');
        $objWriter->writeAttribute('uri', '{3e2802c4-a4d2-4d8b-9148-e3be6c30e623}');
        $objWriter->startElement('xlrd:rvb');
        $objWriter->writeAttribute('i', '0');
        $objWriter->endElement(); // xlrd:rvb
        $objWriter->endElement(); // ext
        $objWriter->endElement(); // extLst
        $objWriter->endElement(); // bk
        $objWriter->endElement(); // futureMetadata XLRICHVALUE

$objWriter->startElement('cellMetadata');
        $objWriter->writeAttribute('count', '1');
        $objWriter->startElement('bk');
        $objWriter->startElement('rc');
        $objWriter->writeAttribute('t', '1');
        $objWriter->writeAttribute('v', '0');
        $objWriter->endElement(); // rc
        $objWriter->endElement(); // bk
        $objWriter->endElement(); // cellMetadata

$objWriter->startElement('valueMetadata');
        $objWriter->writeAttribute('count', '1');
        $objWriter->startElement('bk');
        $objWriter->startElement('rc');
        $objWriter->writeAttribute('t', '2');
        $objWriter->writeAttribute('v', '0');
        $objWriter->endElement(); // rc
        $objWriter->endElement(); // bk
        $objWriter->endElement(); // valueMetadata

$objWriter->endElement(); // metadata

// Return
        return $objWriter->getData();
    }
}

Batal

⬅ Naik ke Writer 19 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘AutoFilter.php	php	4.8 KB	2025-06-23 01:23	✏️ Edit 👁️ View
🐘Chart.php	php	79.2 KB	2025-06-23 01:23	✏️ Edit 👁️ View
🐘Comments.php	php	8.6 KB	2025-06-23 01:23	✏️ Edit 👁️ View
🐘ContentTypes.php	php	12.9 KB	2025-06-23 01:23	✏️ Edit 👁️ View
🐘DefinedNames.php	php	8.6 KB	2025-06-23 01:23	✏️ Edit 👁️ View
🐘DocProps.php	php	8.6 KB	2025-06-23 01:23	✏️ Edit 👁️ View
🐘Drawing.php	php	22.6 KB	2025-06-23 01:23	✏️ Edit 👁️ View
🐘FunctionPrefix.php	php	5.8 KB	2025-06-23 01:23	✏️ Edit 👁️ View
🐘Metadata.php	php	5.2 KB	2025-06-23 01:23	✏️ Edit 👁️ View
🐘Rels.php	php	17.4 KB	2025-06-23 01:23	✏️ Edit 👁️ View
🐘RelsRibbon.php	php	1.6 KB	2025-06-23 01:23	✏️ Edit 👁️ View
🐘RelsVBA.php	php	1.2 KB	2025-06-23 01:23	✏️ Edit 👁️ View
🐘StringTable.php	php	12.7 KB	2025-06-23 01:23	✏️ Edit 👁️ View
🐘Style.php	php	25.4 KB	2025-06-23 01:23	✏️ Edit 👁️ View
🐘Table.php	php	4.7 KB	2025-06-23 01:23	✏️ Edit 👁️ View
🐘Theme.php	php	21.2 KB	2025-06-23 01:23	✏️ Edit 👁️ View
🐘Workbook.php	php	8.2 KB	2025-06-23 01:23	✏️ Edit 👁️ View
🐘Worksheet.php	php	76.8 KB	2025-06-23 01:23	✏️ Edit 👁️ View
🐘WriterPart.php	php	489 B	2025-06-23 01:23	✏️ Edit 👁️ View