Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XSLT XML Mapping Excel "Map Each Element" "XML Source"
For starters ... I'm using 2003 (I have 2007 available if I need it)
1. Import XML using Data-Import External Data-New Web Query That works great. 2. Data-XML-XML Source brings up the XML Source pane The online help tells you that you can drag and drop elements on to a Worksheet. But I can't figure out how to make it so that, say, element 1 goes into rows 1-49 and element 2 goes into rows 50-99 etc. Can this be done through the drag and drop interface? Might someone know of a tutorial that shows how to do this (and not just a generic Excel/XML/Tutorial)? If it's not possible to do this, is the plan for developers to save the XSLT and tweak it so that an MSXML transformation does the mapping into the rows for you? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |