- simplexml_load_string: documentation ( source)
<?php
$x = <<<XML
<XL>
<Row>
<Cell><Data Type="String">Dr. nair</Data></Cell>
<Cell><Data Type="String">12121 brok Blvd. </Data></Cell>
<Cell><Data Type="String">WEST INDIES</Data></Cell>
<Cell><Data Type="String">WI</Data></Cell>
<Cell><Data Type="Number">90025</Data></Cell>
<Cell><Data Type="String">310-444-1212</Data></Cell>
</Row>
<Row>
<Cell><Data Type="String">Dr. july</Data></Cell>
<Cell><Data Type="String">Paldi. </Data></Cell>
<Cell><Data Type="String">WEST INDIES</Data></Cell>
<Cell><Data Type="String">WI</Data></Cell>
<Cell><Data Type="Number">90025</Data></Cell>
<Cell><Data Type="String">310-4544-1212</Data></Cell>
</Row>
<Row>
<Cell><Data Type="String">Dr. lol</Data></Cell>
<Cell><Data Type="String">Paldi. </Data></Cell>
<Cell><Data Type="String">New Zeland</Data></Cell>
<Cell><Data Type="String">NZ</Data></Cell>
<Cell><Data Type="Number">90025</Data></Cell>
<Cell><Data Type="String">310-4544-1212</Data></Cell>
</Row>
<Row>
<Cell><Data Type="String">Dr. nik</Data></Cell>
<Cell><Data Type="String">Paldi. </Data></Cell>
<Cell><Data Type="String">India</Data></Cell>
<Cell><Data Type="String">IN</Data></Cell>
<Cell><Data Type="Number">90025</Data></Cell>
<Cell><Data Type="String">310-4544-1212</Data></Cell>
</Row>
</XL>
XML;
$xml = simplexml_load_string($x);
$countries = $xml->xpath("//Row/Cell[3]/Data");
foreach ($countries as $c) echo "$c, ";