php parse xml problems

Question

I'm trying to parse an xml generated by excel, but i'm hitting a stag. I cant get anywhere below the Workbook node:

$benregxml = simplexml_load_file('00_ben_reg_main.xml');
$wrkbook = $benregxml->Workbook->Worksheet;
print_r($wrkbook);

If i log Workbook, that works (output is SimpleXMLElement Object ( )).

I'm actually trying to get the row node, but nothing i try appears to work.

Excel XML code looks like this:




    
        Ognen Plavevski
        Ognen Plavevski
        2013-05-24T20:28:09Z
        14.00
    
    
        
    
    
        10035
        22995
        480
        45
        False
        False
    
    
        
        
    
    
        
                
                    ID
                
                
                    PARENT_RECORD_ID
                
                
                    PARENT_PAGE_ID
                
                
                    PARENT_ELEMENT_ID
                
                
                    CREATED_DATE
                
                
                    CREATED_BY
                
                
                    CREATED_LOCATION
                
                
                    CREATED_DEVICE_ID
                
                
                    MODIFIED_DATE
                
                
                    MODIFIED_BY
                
                
                    MODIFIED_LOCATION
                
                
                    MODIFIED_DEVICE_ID
                
            
            
        
        
            
                
                
                
            
            
            
                
                    3
                    R1C1:R101C19
                
            
            False
            False
        
    
    
        
        
            
                
                
                
            
            False
            False
        
    
    
        
        
            
                
                
                
            
            False
            False

Alkis Kalogeris · Accepted Answer

Try this

$benregxml = simplexml_load_file('00_ben_reg_main.xml');
$wrkbook = $benregxml->Worksheet[0]->Table->Row;
print_r($wrkbook);

It's your level that is the problem and of course that you have 3 Worksheet tags (so it's an array). The workbook tag is the head, so $benregxml = Workbook from the start

UPDATE

$benregxml = simplexml_load_file('00_ben_reg_main.xml');
$cells = $benregxml->Worksheet[0]->Table->Row[0];
//You need Row[0] because Row will return object, but you want just the content, 
    //which is the array of cells.
echo ""; print_r($cells); echo "";

echo "
----------------------------------------------------------------
";
foreach( $cells as $cell ) {

    echo ""; print_r($cell); echo "";
}

Just to clarify, Row returns SimpleXMLElement Object which as you see in the output consists of an array of SimpleXMLElement Object of cells. If you want the object you want Row, but if you want the actual array you need Row[0]. If you find this difficult to understand I advise you to check the json format. It will help a lot. Hope this helps.

php parse xml problems

Answers (1)

Related Questions