how to get the inner node and its children value of xml document in c#

Question

i have an xml document like the below

 <?xml version='1.0'?>
<ENVELOPE>
<HEADER>
    <TALLYREQUEST>Import Data</TALLYREQUEST>
</HEADER>
<BODY>
    <IMPORTDATA>
        <REQUESTDESC><REPORTNAME>All Masters</REPORTNAME><STATICVARIABLES><SVCURRENTCOMPANY>MSIT</SVCURRENTCOMPANY></STATICVARIABLES></REQUESTDESC>
        <REQUESTDATA>
            <TALLYMESSAGE>
<Entry_x0020_NO.>125</Entry_x0020_NO.>
<DATE>12</DATE>
<GUID>1258</GUID>
<NARRATION>1542</NARRATION>
<VOTURETYPENAME>456</VOTURETYPENAME>
<NAME>achuth</NAME>
<AMOUNT>250</AMOUNT>
  </TALLYMESSAGE>
        </REQUESTDATA>
    </IMPORTDATA>
</BODY>
</ENVELOPE>

in which i need to get the inner node tally Message and its children inner text values using c# code in a loop and make each node as excel sheet column name and the values as row values in excel. the error is below

Hari Prasad · Accepted Answer · 2016-04-10T10:11:22.083

1

You could do this, solution uses Linq to Xml.

    XDocument doc = XDocument.Load(filename);

    var messages = doc.Descendants("TALLYMESSAGE").Select(s=> new {
        Entry =  s.Element("Entry_x0020_NO.").Value,
        DATE =  s.Element("DATE").Value,
        GUID =  s.Element("GUID").Value,
        NARRATION =  s.Element("NARRATION").Value,
        VOTURETYPENAME =  s.Element("VOTURETYPENAME").Value,
        AMOUNT =  s.Element("AMOUNT").Value,
        NAME =  s.Element("NAME").Value,

    }).ToList();

Update : As asked in comments, if you are looking to loop through each elements you could do this.

    foreach(var element in doc.Descendants("TALLYMESSAGE").Elements()) 
    {
        Console.WriteLine("{0} = {1}", element.Name, element.Value);
    }

Check this Example

edited Apr 10 '16 at 10:11

answered Apr 10 '16 at 09:50

Hari Prasad

16,716
4
21
35

can i save each as row of excel document? – Achuth hadnoor Apr 10 '16 at 09:59
That can be done, you have to write the logic to write to excel. – Hari Prasad Apr 10 '16 at 10:02
instead of for each i need to use the for loop to insert – Achuth hadnoor Apr 10 '16 at 10:05
can i use each as separately so that i can transfer each value – Achuth hadnoor Apr 10 '16 at 10:10
can u help me to create an excel sheet integration in which the child nodes of tally message are the column names and values are its rows? – Achuth hadnoor Apr 10 '16 at 10:24
I suggest post new Question. – Hari Prasad Apr 10 '16 at 10:28
It might mislead people reaching this post with similar problem, so always best to post specific question to each problem. – Hari Prasad Apr 10 '16 at 10:41
can u jest print to a message box instead of console – Achuth hadnoor Apr 10 '16 at 11:06
`MessageBox.Show(string.Format("{0} = {1}", element.Name, element.Value));` – Hari Prasad Apr 10 '16 at 11:18
how to get length of the children so that i can insert into excel using loop xlWorkSheet.Cells[i,i+1]; – Achuth hadnoor Apr 10 '16 at 11:29
You cal use Elements.Count() to know number of elements – Hari Prasad Apr 10 '16 at 13:23

how to get the inner node and its children value of xml document in c#

1 Answers1