how to convert xml to csv in c# .net

Question

2.50/5 (2 votes)

See more:

Hai to all,

I want to convert xml file into csv format in web application.How can i do.I tried lot.But after clicking a button it going straightly into excelsheet only but not csv.plz help me

Below is the sample code.

 //sample.xml
  <authors_table>
  <authors>
    <au_id>172-32-1176</au_id>
    <au_lname>White</au_lname>
    <au_fname>Johnson</au_fname>
    <phone>408 496-7223</phone>
    <address>10932 Bigge Rd.</address>
    <city>Menlo Park</city>
    <state>CA</state>
    <zip>94025</zip>
    <contract>true</contract>
  </authors>
<authors_table></authors_table></authors_table>

output as
172-32-1176,white,johnson,408 496-7223,10932 Bigge Rd.,Menlo Park,CA,94025,true

Posted 22-Mar-11 0:00am

sridharan28

Updated 28-Dec-21 19:03pm

Pranit Kothari

v3

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manas Bhardwaj · Answer 1 · 2011-03-22T00:13:00

Solution 1

if I understand correctly, you already have the implementation to convert xml to csv, right?

Do you mean that your output csv file gets opened up in Excel? The reason for that is that you have default program for opening csv files set to Excel.

Posted 22-Mar-11 0:13am

Manas Bhardwaj

Updated 22-Mar-11 7:00am

v2

Comments

sridharan28 22-Mar-11 6:15am

will u plz tell me any suitable link for this?

avigodse 22-Mar-11 9:50am

Just Right-Click on the file in file browser and Select 'Open With' from context menu; and from Popped list, select 'Notepad' like any text editor.

Sergey Alexandrovich Kryukov · Answer 2 · 2011-03-22T07:01:00

Solution 2

You never "convert" it. No matter how you do it you loose some information.

—SA

Posted 22-Mar-11 7:01am

Sergey Alexandrovich Kryukov

iamthechamp247 · Answer 3 · 2012-11-08T16:49:00

The following method would exactly suffice your requirement.
As I faced the same issue and happen to write the following code to get what I needed.

This converts the DataSet to XML and then to text/csv as you can see. There are few other ContentTypes that you may use to get what's required.

XML File:

XML

<NewTable>
     <Table>
          <a1>12345</a1>
          <a2>12345</a2>
          <a3>12345</a3>
          <a4>12345</a4>
          <a5>12345</a5>
     </Table>
</NewTable>

Function:

C#

protected string ConvertToCSV(DataSet objDataSet)
{
        string xmlInput = objDataSet.GetXml();
        string csvOut = string.Empty;
        XDocument doc = XDocument.Parse(xmlInput);
        StringBuilder sb = new StringBuilder(100000);
        foreach (XElement node in doc.Descendants("Table"))
        {
            foreach (XElement innerNode in node.Elements())
            {
                //"{0}," give you the output in Comma seperated format.
                sb.AppendFormat("{0},", innerNode.Value);
            }
            sb.Remove(sb.Length - 1, 1);
            sb.AppendLine();
        }
        csvOut = sb.ToString();
        Response.ClearHeaders();
        Response.ClearContent();
        Response.ContentType = "text/csv";
        Response.ContentEncoding = Encoding.GetEncoding(0);
        Response.AppendHeader("Content-Disposition", "attachment;filename=Report.csv");
        Response.Output.Write(csvOut);
        Response.End();
        return csvOut;
}

Ravi barnwal · Answer 4 · 2021-12-28T19:03:00

public static void ConvertToCsv(string SourceFilePath)
       {
           FileInfo fi = new FileInfo(SourceFilePath);

           string FileName = fi.Name.Split('.')[0].ToString();
           string directoryName = fi.DirectoryName + "\\";
           string extn = fi.Extension;

           DataSet ds = new DataSet();

           ds.ReadXml(SourceFilePath);

           string XmlFileDate = FileName.Split('_')[0].ToString();
           string XmlFolderPath = directoryName + XmlFileDate;

           StringBuilder sb = new StringBuilder();

           foreach (DataTable dt in ds.Tables)
           {
               foreach (DataColumn col in dt.Columns)
               {
                   if (col.DataType == typeof(string))
                       sb.Append(dt.TableName + "_" + col.ColumnName + ", ");
               }
           }
           sb.Append(Environment.NewLine);

           foreach (DataTable dt in ds.Tables)
           {
               foreach (DataRow row in dt.Rows)
               {
                   for (int i = 0; i < dt.Columns.Count; i++)
                   {
                       if (dt.Columns[i].DataType == typeof(string))
                       {
                           string sRowVal = row[i].ToString().Replace("\r\n", " ");
                           sb.Append(sRowVal + ", ");
                       }

                   }
               }
           }
           sb.Remove(sb.Length - 2, 1);
           sb.Append(Environment.NewLine);

           File.WriteAllText(XmlFolderPath + "\\" + XmlFileDate + ".csv", sb.ToString());
       }

how to convert xml to csv in c# .net

4 solutions

Solution 1

Solution 2

Solution 3

Solution 5

Add your solution here

Preview 0