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
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