Home » Forums » Open Source Learning Center » Question and Answer

How to extract data from XML file on Excel .

shreeom17's picture
Submitted by shreeom17 on 12 January, 2014 - 02:11

Hi Team,

I have one XML File "Formdata.xml" ,which is saved on local drive .I want to show this xml data on Excel file .

On excel , left hand side has parameter .and I want to show respective xml data on righr side as

ACCOUNT NO : XX

MOBILE NO : XX

Could you please tell me code How to show that on excel ?

‹ COPY ROWS IN MULTIPLE WORKSHEETS IF COLUMN EQUALS A NUMERIC VALUE Need Help Arranging the Fields and respective data in an order. ›
»

Assuming you're using Excel

Submitted by chris on 20 January, 2014 - 18:32.

Assuming you're using Excel 2007 or above, turn on the "Developer" ribbon tab (in the options) and then from there choose "Import" from the XML ribbon section. I think you should end up with what you're after!

Chris

»