XML to Excel conversion issue

N

Nirad

Dear folks,
I have generated XML file and its a table. I have given
defination below.Now when i open this xml file is MS-EXCEL 2003 i get output
like this

/asx:abap
/@version /@version/#agg /asx:values/TAB/SFLIGHT/CARRID
1 1 LH
but i want output like this

version agg carrid
1 1 LH

How can i get it??I have MS-EXCEL 2003 version (11.8117.8107).My friend who
has different version of excel 2003 can see this file perfectly without
having problem.Can anyone guide me.

Definition:
<?xml version="1.0" encoding="iso-8859-1" ?>
- <asx:abap xmlns:asx="http://www.sap.com/abapxml" version="1.0">
- <asx:values>
- <TAB>
- <SFLIGHT>
<MANDT>330</MANDT>
<CARRID>LH</CARRID>
<CONNID>0400</CONNID>
<FLDATE>2006-11-25</FLDATE>
<PRICE>666.0</PRICE>
<CURRENCY>EUR</CURRENCY>
</SFLIGHT>
</TAB>
</asx:values>
</asx:abap>
 
J

Joel

It depends on what XML reader is installed on each PC. When your friend
opens the XML file find out what program open the file. You either don't
have the same program installed or you are using a different default for
opening the file.

To change your default program for XML go to a window explorer and select
the .XML file. Then right click on mouse and choose "OPEN WITH" - Choose
program. Seloect program and check the box ALWAYS USE SELECTED PROGRAM.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top