Monday, August 1, 2016

viewing XML files to EXCEL files and vice versa and conversion process.


(viewing XML Contents as excel file, )
Suppose if you have sample xml file, which you want to view in EXCEL instead of XML format.
Step1: simply drag the file from desktop to your required cell in excel sheet.(choose 1st radio button option)

Step2: if you want to see the structure of xml file, choose (Developer, source option as shown in the image)

Step3: suppose, if you want to see the heading part( full xpath of the element, at the time dragging it will ask you 3 radio buttons, choose 2nd option);

Step 4: if you need only structure as shown in below image(right side), use 3rd option to view only structure.