<?php
$Value = 'rId4';
$rels= new SimpleXMLElement('<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Id="rId3" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/theme" Target="theme/theme1.xml"/><Relationship Id="rId2" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet2.xml"/><Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet1.xml"/><Relationship Id="rId5" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/sharedStrings" Target="sharedStrings.xml"/><Relationship Id="rId4" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles" Target="styles.xml"/></Relationships>');
$rels->registerXPathNamespace('r', 'http://schemas.openxmlformats.org/package/2006/relationships');
$elems = $rels->xpath('/r:Relationships/r:Relationship[@Id and @Target and @Type = \'http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet\']');
print_r($elems);
$map = [];
foreach ( $elems as $elem ) {
$map[(string)$elem->Id] = (string)$elem->Target;
}
print_r($map);
- Output for 5.5.24 - 5.5.35, 5.6.8 - 5.6.28, 7.0.0 - 7.0.20, 7.1.0 - 7.1.10, 7.2.0 - 7.2.33, 7.3.16 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.6
- Array
(
[0] => SimpleXMLElement Object
(
[@attributes] => Array
(
[Id] => rId2
[Type] => http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet
[Target] => worksheets/sheet2.xml
)
)
[1] => SimpleXMLElement Object
(
[@attributes] => Array
(
[Id] => rId1
[Type] => http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet
[Target] => worksheets/sheet1.xml
)
)
)
Array
(
[] =>
)
preferences:
156.39 ms | 405 KiB | 181 Q