Convert XML file to csv file format in c#

Question

I am using accord.net mouse gesture recognition sample application, which saves the file in above xml format. I need help to convert above xml in to CSV format so i can do machine learning using accord.net Dynamic time warping. I can not figure out how to convert in to csv file.

For example: 261,210,261,214,261,229,261,231

<?xml version="1.0"?>
<ArrayOfSequence xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <Sequence>
    
    <SourcePath>
      <Point>
        <X>261</X>
        <Y>210</Y>
      </Point>
      <Point>
        <X>261</X>
        <Y>214</Y>
      </Point>
      <Point>
        <X>261</X>
        <Y>227</Y>
      </Point>
      <Point>
        <X>261</X>
        <Y>229</Y>
      </Point>
      <Point>
        <X>261</X>
        <Y>231</Y>
      </Point>
      <Point>
        <X>261</X>
        <Y>234</Y>
      </Point>
      <Point>
        <X>261</X>
        <Y>237</Y>
      </Point>
</Sequence>
</ArrayOfSequence>

i found the source code on accord.net framework website which is using XML Serialization to save file. — Sohaib Omar
– Sohaib Omar, Commented Feb 25, 2016 at 13:31

NoName · Accepted Answer · 2016-02-25 14:24:43Z

11

using System.IO;
using System.Xml.Serialization;

You can do like this:

public class Sequence
{
    public Point[] SourcePath { get; set; }
}

using (FileStream fs = new FileStream(@"D:\youXMLFile.xml", FileMode.Open))
{
    XmlSerializer serializer = new XmlSerializer(typeof(Sequence[]));
    var data=(Sequence[]) serializer.Deserialize(fs);
    List<string> list = new List<string>();
    foreach(var item in data)
    {
        List<string> ss = new List<string>();
        foreach (var point in item.SourcePath) ss.Add(point.X + "," + point.Y);
        list.Add(string.Join(",", ss));
    }
    File.WriteAllLines("D:\\csvFile.csv", list);
}

edited Feb 25, 2016 at 14:24

answered Feb 25, 2016 at 14:00

NoName

8,06516 gold badges62 silver badges114 bronze badges

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

3 Comments

Sohaib Omar Over a year ago

Above code is writing into csv file as {X=261,Y=210},{X=261,Y=214},{X=261,Y=227},{X=261,Y=229}. I need my points as 261,210,261,214,261,227,261,229

Rob Over a year ago

so this is slightly buggy as a general solution, as it doesn't escape commas or quotes.

NoName Over a year ago

@Rob this answer is for specific problem, not for general.

Community · Accepted Answer · 2020-06-20 09:12:55Z

In an alternate way you can use leverage the power of XSLT to convert it,

Steps

Create an Xml stylesheet to convert xml to csv
Use XslCompiledTransform() to convert get the csv string
save the csv string to a file

You may came up with an Xslt like this, call it data.xsl

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="text" version="1.0" encoding="UTF-8"/>
  <xsl:template match="/">
    <xsl:for-each select="//Point">
      <xsl:value-of select="X"/>,<xsl:value-of select="Y"/>
      <xsl:text>&#xD;&#xA;</xsl:text>
    </xsl:for-each>
  </xsl:template>
</xsl:stylesheet>

and use the following method

public static string ToCSV(string xmlTextDate, string xsltFile)
{
  string result = string.Empty;
  var xpathDoc = new XPathDocument(xmlTextDate);
  var xsltTransform = new System.Xml.Xsl.XslCompiledTransform();
  xsltTransform.Load(xsltFile);

  using (MemoryStream ms = new MemoryStream())
  {
      var writer = new XmlTextWriter(ms, Encoding.UTF8);
      using (var rd = new StreamReader(ms))
      {
          var argList = new System.Xml.Xsl.XsltArgumentList();
          xsltTransform.Transform(xpathDoc, argList, writer);
          ms.Position = 0;
          result = rd.ReadToEnd();
      }
  }
  return result;
}

and call it like this

var csvString = ToCSV("yourfile.xml","data.xsl");

fcdt · Accepted Answer · 2020-10-01 15:10:58Z

3

Converting XML directly into CSV is a little complex task. Instead of this, you can first convert your XML to DataSet and then into CSV:

Converting XML to Dataset:

DataSet ds = new DataSet();

ds.ReadXml(fileNamePath);

Converting DataTable to CSV.

Link: c# datatable to csv

edited Oct 1, 2020 at 15:10

fcdt

2,5215 gold badges17 silver badges27 bronze badges

answered Oct 1, 2020 at 14:32

Ravi Kumar

311 bronze badge

Comments

Nonagon · Accepted Answer · 2016-02-25 13:51:47Z

-12

Just create a csv file of the XML, Use System.IO and make sure the file is something like

fileName = Name + ".csv"

Have a read up and look for something like this

Path.GetTempPath(), fileName

I am a bit sketchy but that should put you on the right track

answered Feb 25, 2016 at 13:51

Nonagon

4072 gold badges6 silver badges22 bronze badges

5 Comments

Sohaib Omar Over a year ago

i tried but it did not work. i only need x and y co-ordinates in my csv file.

Sohaib Omar Over a year ago

for example: 261,210,261,214,261,231,261,234

Nonagon Over a year ago

Im not sure the exact syntax but it should have something to do with that

Anonymous Over a year ago

This isn't even close to answering the OPs question.

Vinod Srivastav Over a year ago

filename will be like "Name.csv" and Path.GetTempPath() gives Returns the path of the current user's temporary folder that won't transform xml to csv. Consider editing your post else you will keep getting downvoted.

Collectives™ on Stack Overflow

Convert XML file to csv file format in c#

4 Answers 4

3 Comments

Steps

Comments

Comments

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Steps

Comments

Comments

5 Comments

Linked

Related