| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XML Data
Is there any way to create a program to turn data I may be viewing as an xml
list in excel, to return a record where all attributes of the record are in ONE record row. I have an xml file where the data many times is displayed across several rows in excel. Trying to sort on the data then becomes extrememly problematic. I would like to view the xml data in excel like I could when importing a txt file. Is this possible using xml in excel? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
XML Data
On Nov 20, 3:03*pm, Jcraig713
wrote: Is there any way to create a program to turn data I may be viewing as an xml list in excel, to return a record where all attributes of the record are in ONE record row. *I have an xml file where the data many times is displayed across several rows in excel. *Trying to sort on the data then becomes extrememly problematic. *I would like to view the xml data in excel like I could when importing a txt file. *Is this possible using xml in excel? try using the SPLIT function with < and or use MID while looping through the text. could you share some sample data? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save 60% on Data Entry, Data Conversion, Data Processing Services byOffshore-Data-Entry | Excel Programming | |||
| Save 60% on Data Entry, Data Conversion, Data Processing Services byOffshore-Data-Entry | Excel Programming | |||
| Reliable Data Conversion,Data Formats and Data Entry Services by DataEntry India | Excel Programming | |||
| Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
| Excel Macro for taking data external data and populating it on a sheet and deleting unwanted data | Excel Programming | |||
Hybrid Mode
