How to update excel data into existing XML file using PHP

Question

I want to add excel file data into an existing XML file and a particular tag.

I want to add excel data of upc code into the upc tag of the XML file using PHP.

My excel file format is:

I want the following XML format data.

What have you tried, researched ? We can help you on a precise point, but you need to show some effort trying to solve this problem by yourself first. — Pac0
– Pac0, Commented Aug 30, 2017 at 20:57

Amol Kumbhar · Accepted Answer · 2017-08-31 18:05:42Z

2

 $xml = simplexml_load_file("yourxmlfilename.xml");
 $prod = $xml->Products;
 print_r($prod->Product->count());
 for($i=1; $i<=$prod->Product->count();$i++){
   $str = (string) $prod->Product[$i]->ExternalId;
if($str == 'mobilesn1'){
    $c = $prod->Product[$i]->UPCs;
    print_r($prod->Product[$i]->UPCs->UPC);
    if((string)$prod->Product[$i]->UPCs->UPC !="895623" ){
    //unset($prod->Product[$i]->UPCs->UPC);
    $c->addChild('UPC', '895623');
    $xml->asXML("yourxmlfilename.xml");
    }
  }
}

edited Aug 31, 2017 at 18:05

answered Aug 31, 2017 at 18:00

Amol Kumbhar

3291 gold badge4 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to update excel data into existing XML file using PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related