Read XML Data and Pass to excel

Question

Dear All I am a very new in C# I use to try only in VBA in excel. how to write code using visual C# use Windows Application Form to read XML data in XML file and pass to Excel worksheet? Thanks and Best Regards; BL

vijay bhardwaj · Answer

XNamespace ss = urn:schemas-microsoft-com:office:spreadsheet; XDocument sheet = XDocument.Load(@YourXMLFile.xml); foreach (XElement worksheet in sheet.Root.Elements(ss + Worksheet)) { Console.WriteLine(Worksheet: {0} worksheet.Attribute(ss + Name).Value); foreach (XElement row in worksheet.Element(ss + Table).Elements(ss + Row)) { foreach (XElement cell in row.Elements(ss + Cell)) { Console.Write({0}	 cell.Value); } Console.WriteLine(); } Console.WriteLine(); }

chen boly · Answer

Dear vijay bhardwaj  Thank you for your response. However like I mention in my first post I am very new in C# I really not understand about your code. If you don't mind could you please provide me the example to read the XML file as in attached. I just want to read all the value in =Value attribute in XML and pass the data into worksheet (excel) respectively by the StationName. Example: Worksheet Name CSA must be store value from CSA in XML file. Hope you can help. Best Regards; BL