DOMDocument :: load - PHP - 获取属性值 [英] DOMDocument::load - PHP - Getting attribute value

问题描述

我正在努力从 ss：ExpandedColumnCount =3在

<$ p中获取值3 $ p> < Table ss：ExpandedColumnCount =3ss：ExpandedRowCount =2x：FullColumns =1
x：FullRows =1ss：DefaultColumnWidth =65 SS：DefaultRowHeight = 15 >
< Row>
< Cell>< Data ss：Type =String> cat< / Data>< / Cell>
< Cell>< Data ss：Type =String> dog< / Data>< / Cell>
< Cell>< Data ss：Type =String> horse< / Data>< / Cell>
< / Row>
< Row>
< Cell>< Data ss：Type =String> ve< / Data>< / Cell>
< Cell>< Data ss：Type =String> as< / Data>< / Cell>
< Cell>< Data ss：Type =String> fs< / Data>< / Cell>
< / Row>
< Row>
< Cell>< Data ss：Type =String> ve< / Data>< / Cell>
< Cell>< Data ss：Type =String> as< / Data>< / Cell>
< Cell>< Data ss：Type =String> fs< / Data>< / Cell>
< / Row>
< /表>


我在使用XLS文件的PHP中使用DOMDocument :: load。任何帮助将不胜感激。

Cheers

解决方案

加载文档

  libxml_use_internal_errors（TRUE）; 
 $ dom = new DOMDocument; 
 $ dom-> load（'YourExcel.xml'）; 
  

然后执行

  echo $ dom-> documentElement-> getAttribute（'ExpandedColumnCount'）; 
  

或使用XPath

  $ xp = new DOMXPath（$ dom）; 
 echo $ xp-> evaluate（'string（/ Table / @ ExpandedColumnCount）'）; 
  

两者都将返回3。

I am struggling to get the value of 3 from the ss:ExpandedColumnCount="3" in

<Table ss:ExpandedColumnCount="3" ss:ExpandedRowCount="2" x:FullColumns="1"
   x:FullRows="1" ss:DefaultColumnWidth="65" ss:DefaultRowHeight="15">
   <Row>
    <Cell><Data ss:Type="String">cat</Data></Cell>
    <Cell><Data ss:Type="String">dog</Data></Cell>
    <Cell><Data ss:Type="String">horse</Data></Cell>
   </Row>
   <Row>
    <Cell><Data ss:Type="String">ve</Data></Cell>
    <Cell><Data ss:Type="String">as</Data></Cell>
    <Cell><Data ss:Type="String">fs</Data></Cell>
   </Row>
 <Row>
    <Cell><Data ss:Type="String">ve</Data></Cell>
    <Cell><Data ss:Type="String">as</Data></Cell>
    <Cell><Data ss:Type="String">fs</Data></Cell>
   </Row>
  </Table>

I am using DOMDocument::load in PHP using an XLS file. Any help would be greatly appreciated.

Cheers

解决方案

Load the document

libxml_use_internal_errors(TRUE);
$dom = new DOMDocument;
$dom->load('YourExcel.xml');

and then either do

echo $dom->documentElement->getAttribute('ExpandedColumnCount');

or use XPath

$xp = new DOMXPath($dom);
echo $xp->evaluate('string(/Table/@ExpandedColumnCount)');

Both will return 3.

这篇关于DOMDocument :: load - PHP - 获取属性值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！