View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default XML to Excel conversion issue

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.

"Nirad" wrote:

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
<MANDT330</MANDT
<CARRIDLH</CARRID
<CONNID0400</CONNID
<FLDATE2006-11-25</FLDATE
<PRICE666.0</PRICE
<CURRENCYEUR</CURRENCY
</SFLIGHT
</TAB
</asx:values
</asx:abap