Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XML File Import To Excel issue

Status
Not open for further replies.

premachandran

Programmer
Oct 14, 2008
1
Hi

I need to import the data from an XML file to Excel Sheet .I m getting the XML file as ....

<Envelope>

<Name>Jill</Name>

<Role>Mgr</Role>

<EmpNo>1</Empno>

<Name>Mill</Name>

<Role>Associate</Role>

<EmpNo>2</Empno>

<Name>Bill</Name>

<Role>Associate</Role>

<EmpNo>3</Empno>

</Envelope>

and on importing this XML file to Excel Sheet it gets arranged like this which is weird

-------------------------------------------------

A B C

------------------------------------------------

Jill

Mill

Bill

Mgr

Associate

Associate

1

2

3





I need the XML file in this format so that the Excel Output is in proper manner

how do i handle this?

<Envelope>

<Customer>

<Name>Jill</Name>

<Role>Mgr</Role>

<EmpNo>1</Empno>

</Customer>

<Customer>

<Name>Mill</Name>

<Role>Associate</Role>

<EmpNo>2</Empno>

</Customer>

..................

......................

</Envelope>

plz help ....

Thks

Premachandran
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top