Altova Mailing List Archives>Archive Index >microsoft.public.xml Archive Home >Recent entries >Thread Prev - Re: Convert XMl to Excel using XLST >Thread Next - Re: Convert XMl to Excel using XLST Re: Convert XMl to Excel using XLSTTo: NULL Date: 1/9/2006 1:50:00 PM sure, that would be fantastic. Thanks heaps. What Ill do is post the XML that the dataset read's in using the DataSet.ReadXML() method. Then you can just create a XML file, and use a dataset to read in the XMl file. That way you can have a play around with it. here is the XML: (Some of it, its quite large) <?xml version="1.0" encoding="utf-8" ?> <AreasRoot> <room name="Entrance Hall"> <item name="Doors"> <roomIndex>0</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="Security Door"> <roomIndex>0</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="Walls"> <roomIndex>0</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="Windows"> <roomIndex>0</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="Blinds/Curtains"> <roomIndex>0</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="Ceiling"> <roomIndex>0</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="Light Fittings"> <roomIndex>0</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="Floor Coverings"> <roomIndex>0</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="Power Points"> <roomIndex>0</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="Built in Cupboard"> <roomIndex>0</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> </room> <room name="Lounge Room"> <item name="Doors"> <roomIndex>1</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="Walls"> <roomIndex>1</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="Windows/Screens"> <roomIndex>1</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="Blinds/Curtains"> <roomIndex>1</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="Ceiling"> <roomIndex>1</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="Light Fittings"> <roomIndex>1</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="Floor Coverings"> <roomIndex>1</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="TV Point"> <roomIndex>1</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="Power Points"> <roomIndex>1</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="Heating"> <roomIndex>1</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="A/C Unit"> <roomIndex>1</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="Built in Cupboard"> <roomIndex>1</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> <item name="Telephone"> <roomIndex>1</roomIndex> <conditionBefore></conditionBefore> <conditionAfter></conditionAfter> <commentsBefore></commentsBefore> <commentsAfter></commentsAfter> </item> </room> <userDetails> <tennant address="" name="" landlord="" leaseDate="" ></tennant> </userDetails> </AreasRoot> Thanks again, if you can get this working I will be very grateful! | ||||||
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | Mobile | Full Site | |||
|
