Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
XML to Excel conversion issue
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell fill color conversion issue | Excel Discussion (Misc queries) | |||
File conversion-text encoding issue | Excel Discussion (Misc queries) | |||
Vlookup text conversion issue | Excel Discussion (Misc queries) | |||
Date conversion issue... again | Excel Discussion (Misc queries) | |||
Date conversion issue "^" symbol | Excel Discussion (Misc queries) |