how to convert xlm file below to excel with nodes as column names and its values as rows in c#

Question

<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>

the above XML is taken as input and convert to excel as below

Entry No.   date  guid   narration   voucher   name   amount  
125         12     1258     1542      456      achuth  250

the code for me throws error null reference as below

take a look at this answer stackoverflow.com/questions/2494967/… — Mostafiz
– Mostafiz, Commented Apr 10, 2016 at 10:54

har07 · Accepted Answer · 2016-04-10 10:55:24Z

1

You can just cast XElement instance to string instead of accessing its Value property to avoid such exception in the case where the target element is not found within a parent element :

......
new YourClass()
{
    YourClassProperty = (string)s.Element("Your_element_that_may_not_exists"),
    ......
}
......

answered Apr 10, 2016 at 10:55

har07

89.5k12 gold badges87 silver badges143 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Achuth hadnoor Over a year ago

i dint get u sorry

har07 Over a year ago

@achuthhadnoor It is likely that one of your s.Element() part returns null, and trying to access Value property of a null should trigger the null reference exception. So instead of doing s.Element(...).Value, try using the the above suggested pattern (string)s.Element(...)

Collectives™ on Stack Overflow

how to convert xlm file below to excel with nodes as column names and its values as rows in c#

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related