Belmondo555
New Member
I have the following XML:\[code\]<?xml version="1.0" encoding="UTF-8"?><gnm:Workbook xmlns:gnm="http://www.gnumeric.org/v10.dtd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.gnumeric.org/v9.xsd"> <office:document-meta xmlns
ffice="urnasis:names:tcpendocument:xmlnsffice:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urnasis:names:tcpendocument:xmlns:meta:1.0" xmlnsoo="http://openoffice.org/2004/office" office:version="1.1"> <office:meta> <dc:creator>Mark Baker</dc:creator> <dc:date>2010-09-01T22:49:33Z</dc:date> <meta:creation-date>2010-09-01T22:48:39Z</meta:creation-date> <meta:editing-cycles>4</meta:editing-cycles> <meta:editing-duration>PT00H04M20S</meta:editing-duration> <meta:generator>OpenOffice.org/3.1$Win32 OpenOffice.org_project/310m11$Build-9399</meta:generator> </office:meta> </office:document-meta></gnm:Workbook>\[/code\]And am trying to read the office:document-meta node to extractthe various elements below it (dc:creator, meta:creation-date, etc.)The following code:\[code\]$xml = simplexml_load_string($gFileData);$namespacesMeta = $xml->getNamespaces(true);$officeXML = $xml->children($namespacesMeta['office']);var_dump($officeXML);echo '<hr />';\[/code\]gives me:\[code\]object(SimpleXMLElement)[91] public 'document-meta' => object(SimpleXMLElement)[93] public '@attributes' => array 'version' => string '1.1' (length=3) public 'meta' => object(SimpleXMLElement)[94]\[/code\]but if I try to read the document-meta element using:\[code\]$xml = simplexml_load_string($gFileData);$namespacesMeta = $xml->getNamespaces(true);$officeXML = $xml->children($namespacesMeta['office']);$docMeta = $officeXML->document-meta;var_dump($docMeta);echo '<hr />';\[/code\]I get\[code\]Notice: Use of undefined constant meta - assumed 'meta' in /usr/local/apache/htdocsNewDev/PHPExcel/Classes/PHPExcel/Reader/Gnumeric.php on line 273int 0\[/code\]I assume that SimpleXML is trying to extract a non-existent node "document" from $officeXML, then subtract the value of (non-existent) constant "meta", resulting in forcing the integer 0 result rather than the document-meta node.Is there a way to resolve this using SimpleXML, or will I be forced to rewrite using XMLReader? Any help appreciated.
ffice="urnasis:names:tcpendocument:xmlnsffice:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urnasis:names:tcpendocument:xmlns:meta:1.0" xmlnsoo="http://openoffice.org/2004/office" office:version="1.1"> <office:meta> <dc:creator>Mark Baker</dc:creator> <dc:date>2010-09-01T22:49:33Z</dc:date> <meta:creation-date>2010-09-01T22:48:39Z</meta:creation-date> <meta:editing-cycles>4</meta:editing-cycles> <meta:editing-duration>PT00H04M20S</meta:editing-duration> <meta:generator>OpenOffice.org/3.1$Win32 OpenOffice.org_project/310m11$Build-9399</meta:generator> </office:meta> </office:document-meta></gnm:Workbook>\[/code\]And am trying to read the office:document-meta node to extractthe various elements below it (dc:creator, meta:creation-date, etc.)The following code:\[code\]$xml = simplexml_load_string($gFileData);$namespacesMeta = $xml->getNamespaces(true);$officeXML = $xml->children($namespacesMeta['office']);var_dump($officeXML);echo '<hr />';\[/code\]gives me:\[code\]object(SimpleXMLElement)[91] public 'document-meta' => object(SimpleXMLElement)[93] public '@attributes' => array 'version' => string '1.1' (length=3) public 'meta' => object(SimpleXMLElement)[94]\[/code\]but if I try to read the document-meta element using:\[code\]$xml = simplexml_load_string($gFileData);$namespacesMeta = $xml->getNamespaces(true);$officeXML = $xml->children($namespacesMeta['office']);$docMeta = $officeXML->document-meta;var_dump($docMeta);echo '<hr />';\[/code\]I get\[code\]Notice: Use of undefined constant meta - assumed 'meta' in /usr/local/apache/htdocsNewDev/PHPExcel/Classes/PHPExcel/Reader/Gnumeric.php on line 273int 0\[/code\]I assume that SimpleXML is trying to extract a non-existent node "document" from $officeXML, then subtract the value of (non-existent) constant "meta", resulting in forcing the integer 0 result rather than the document-meta node.Is there a way to resolve this using SimpleXML, or will I be forced to rewrite using XMLReader? Any help appreciated.