Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I was wondering if someone can help me. This task may be simple for some, but
I'm having some trouble. I have an Excel document, and it isn't "too" complex, but it will not generate the XML correctly. Click the link below for what my Excel document looks like (not the original however). http://i762.photobucket.com/albums/x...celExample.jpg As you can see, each "Description" has data underneath Titles 2-5. Each Description can have multiple of Titles 3-5 but only one of Title2. I want this to be converted into XML. However, I want it to look like this. Code: <node <title1Description1</title1 <title2ID1</title2 <title3 bla="TRUE" <title4ip1</title4 <title5en1</title5 </title3 <title3 bla="FALSE" <title4ip2</title4 <title5en2</title5 </title3 <title3 bla="FALSE" <title4ip3</title4 <title5en3</title5 </title3 <title3 bla="TRUE" <title4ip4</title4 <title5en4</title5 </title3 </node <node <title1Description2</title1 <title2ID2</title2 <title3 bla="TRUE" <title4ip5</title4 <title5en5</title5 </title3 <title3 bla="TRUE" <title4ip6</title4 <title5en6</title5 </title3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Export Excel tuncating leading zeros while export to excel from da | Setting up and Configuration of Excel | |||
Chart.Export images are shrinking as I export more images | Charts and Charting in Excel | |||
export re-order input fields to export file [csv] | Excel Worksheet Functions | |||
Export XML | Excel Worksheet Functions | |||
CSV export help | Excel Discussion (Misc queries) |