przetwazanie pliku XML Opcje

[-Guest-]

chce przetwozyc plik XML a dkoladnie generowany przez Excel wiec wczytuje go przez simplexml i che sie dobrac do atrybutow ale maja one taka postac:

Kod

<Table ss:ExpandedColumnCount="3" ss:ExpandedRowCount="4" x:FullColumns="1"
   x:FullRows="1">
   <Row>
    <Cell><Data ss:Type="String">kolumna1</Data></Cell>
    <Cell ss:MergeAcross="1"><Data ss:Type="String">kolumna2_zlacz</Data></Cell>
   </Row>
   <Row>
    <Cell><Data ss:Type="String">aaa</Data></Cell>
    <Cell><Data ss:Type="String">bbbb</Data></Cell>
    <Cell><Data ss:Type="String">ccc</Data></Cell>
   </Row>
   <Row>
    <Cell><Data ss:Type="String">SSS</Data></Cell>
    <Cell><Data ss:Type="String">SWE</Data></Cell>
    <Cell><Data ss:Type="String">TEST</Data></Cell>
   </Row>
   <Row>
    <Cell><Data ss:Type="String">asas</Data></Cell>
    <Cell><Data ss:Type="String">adad</Data></Cell>
    <Cell><Data ss:Type="String">afaf</Data></Cell>
   </Row>
  </Table>

nie wiem jak sie dobrac do ss:ExpandedColumnCount

[PHP] pobierz, plaintext 
<?php
$xml = simplexml_load_file('test.xml');
echo $xml->Table['ExpandedColumnCount'];
 
?>
[PHP] pobierz, plaintext 

to cos takiego nie dziala (IMG:http://forum.php.pl/style_emoticons/default/sad.gif) jak dam $xml->Table['ss:ExpandedColumnCount']; to tez nie (IMG:http://forum.php.pl/style_emoticons/default/sad.gif) wiec jak mam sie do tego dobrac?(IMG:http://forum.php.pl/style_emoticons/default/questionmark.gif)

[-Guest-]

niebardzo (IMG:http://forum.php.pl/style_emoticons/default/sad.gif)

caly plik XML wyglada tak:

[XML] pobierz, plaintext 
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <Author>zzz</Author>
  <LastAuthor>zzz</LastAuthor>
  <Created>2006-01-15T14:03:24Z</Created>
  <Company>niepowiem</Company>
  <Version>11.6505</Version>
 </DocumentProperties>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>13185</WindowHeight>
  <WindowWidth>15120</WindowWidth>
  <WindowTopX>480</WindowTopX>
  <WindowTopY>30</WindowTopY>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Bottom"/>
   <Borders/>
   <Font x:CharSet="238"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
 </Styles>
 <Worksheet ss:Name="Arkusz1">
  <Table ss:ExpandedColumnCount="3" ss:ExpandedRowCount="4" x:FullColumns="1" x:FullRows="1">
   <Row>
    <Cell><Data ss:Type="String">kolumna 1</Data></Cell>
    <Cell><Data ss:Type="String">kolumna 2</Data></Cell>
    <Cell><Data ss:Type="String">kolumna 3</Data></Cell>
   </Row>
   <Row>
    <Cell><Data ss:Type="String">aaa</Data></Cell>
    <Cell><Data ss:Type="String">bbbb</Data></Cell>
    <Cell><Data ss:Type="String">cccc</Data></Cell>
   </Row>
   <Row>
    <Cell><Data ss:Type="String">1q1q1q</Data></Cell>
    <Cell><Data ss:Type="String">2w2w2w</Data></Cell>
    <Cell><Data ss:Type="String">3e3e3e</Data></Cell>
   </Row>
   <Row>
    <Cell><Data ss:Type="String">zzz</Data></Cell>
    <Cell><Data ss:Type="String">xxx</Data></Cell>
    <Cell><Data ss:Type="String">qqq</Data></Cell>
   </Row>
  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <PageSetup>
    <PageMargins x:Bottom="0.984251969" x:Left="0.78740157499999996"
     x:Right="0.78740157499999996" x:Top="0.984251969"/>
   </PageSetup>
   <Selected/>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
</Workbook>
[XML] pobierz, plaintext 

jest to prosty plik excel zapisany jako xml (IMG:http://forum.php.pl/style_emoticons/default/smile.gif) chce wyciagnac z niego miedzy innymi to ss:ExpandedColumnCount="3" a dokladnie wartosc 3 (IMG:http://forum.php.pl/style_emoticons/default/smile.gif)

[PHP] pobierz, plaintext 
<?php
 
$xml = simplexml_load_file('excel.xml');
echo $xml->DocumentProperties->Worksheet->Table['ss:ExpandedColumnCount'];
?>
[PHP] pobierz, plaintext 

to nie dziala (IMG:http://forum.php.pl/style_emoticons/default/sad.gif) ani $xml->DocumentProperties->Worksheet->Table['ExpandedColumnCount'];