XML to CSV parser with column names in C#

Vishal Kaushik

Please help me to parse my xml into csv with column names. I need c# code in order to achieve my task. Below is my xml content:

xml version="1.0" encoding="UTF-8"?>
<soap:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<GetAccountsResponse xmlns="http://Weiland.Ba.retrieval/">
<GetAccountsResult>
<AccountRecords>3071AccountRecords>
<Accounts>
<Account>
<AccountId>6AccountId>
<AccountNumber>000091016138AccountNumber>
<AccountTitle>3946231 Canada Inc.AccountTitle>
<BankId>70BankId>
<BankName>Royal Bank of CanadaBankName>
<BankRtn>ROYCCAT2BankRtn>
<BranchId xsi:nil="true"/>
<CompanyId>86CompanyId>
<CurrencyName>Canada, DollarCurrencyName>
<CostCenter>4603CostCenter>
<ActiveDate>1900-01-01T00:00:00ActiveDate>
Account>
Accounts>
<AsOfDate>2019-10-31 06:04:36.059 -04:00AsOfDate>
<BankRecords>0BankRecords>
<CompanyRecords>0CompanyRecords>
<ReturnCode>0ReturnCode>
<Version>1.03Version>
GetAccountsResult>
GetAccountsResponse>
soap:Body>
soap:Envelope>

I need the value of tags from AccountId to ActiveDate. I have tried looking on google but not able to get right code. Please help me so that I can generate a csv file from above xml content with column names in csv file.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ashutosh Gupta6y ago
https://stackoverflow.com/questions/35628637/convert-xml-file-to-csv-file-format-in-c-sharp
Kunjahamed P6y ago
Try with Cinchoo ETL tool.you can do the conversion easily with few lines of code

its an ETL framework for .NET
Simple, intutive Extract, transform and load (ETL) library for .NET. Extremely fast, flexible, and easy to use.
Cinchoo ETL is a code-based ETL framework for extracting data from multiple sources, transforming, and loading into your very own data warehouse in .NET environment. You can have data in your data warehouse in no time.

using (var r = new ChoXmlReader("*** XML FILE PATH ***")
.WithXPath("soap:Envelope")
)
{
using (var w = new ChoCSVWriter(sb)
.WithFirstLineHeader()
)
w.Write(r);
}
Console.WriteLine(sb.ToString());

Try with latest Pre release version and many configure is avalible