Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
XML Import
Hi,
When I import an xml doc into excel 2007 all the nodes are arranged on one row. I would like for each subnode to be inserted on a new row. My simple xml doc reads as follows: <?xml version="1.0" encoding="utf-8" ? <root <aaaa <english something in english </english <swedish something in swedish </swedish </aaaa <bbbb <english something in english </english <swedish something in swedish </swedish </bbbb </root Importing above xml results in: something in english something in swedish something in english something in swedish when I would like it to result like this: something in english something in swedish something in english something in swedish Never used excel before and would be greatful for any help on this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import from web. | Excel Discussion (Misc queries) | |||
How do i import from ACT! to Excel? | Excel Discussion (Misc queries) | |||
Import xml | Excel Worksheet Functions | |||
import | Excel Discussion (Misc queries) | |||
Need to import to Access | New Users to Excel |