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, Feb 25 '16 at 13:31
Did you search? http://stackoverflow.com/questions/18757097/writing-data-into-csv-file — L-Four, Feb 25 '16 at 14:01
i only need x and y co-ordinates in my csv file. for example: 261,210,261,214,261,231,261,234 — Sohaib Omar, Feb 25 '16 at 14:01
I have file in xml format, i want to conver that in to csv format. for example: 261,210,261,214,261,231,261,234 — Sohaib Omar, Feb 25 '16 at 14:02

NoName · Accepted Answer · 2016-02-25T14:24:43.547

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 '16 at 14:24

answered Feb 25 '16 at 14:00

NoName

7,940
13
56
108

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 – Sohaib Omar Feb 25 '16 at 14:21
so this is slightly buggy as a general solution, as it doesn't escape commas or quotes. – Rob Oct 16 '17 at 23:17
@Rob this answer is for specific problem, not for general. – NoName Oct 17 '17 at 12:33

score 4 · Answer 2 · edited Jun 20 '20 at 09:12

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");

score 3 · Answer 3 · edited Oct 01 '20 at 15:10

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 01 '20 at 15:10

fcdt

2,371
5
14
26

answered Oct 01 '20 at 14:32

Ravi Kumar

31
1

score -12 · Answer 4 · answered Feb 25 '16 at 13:51

-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 '16 at 13:51

Nonagon

397
1
5
21

i tried but it did not work. i only need x and y co-ordinates in my csv file. – Sohaib Omar Feb 25 '16 at 13:59
for example: 261,210,261,214,261,231,261,234 – Sohaib Omar Feb 25 '16 at 14:00
Im not sure the exact syntax but it should have something to do with that – Nonagon Feb 25 '16 at 15:11
3

This isn't even close to answering the OPs question. – Anonymous Apr 19 '18 at 13:28
`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. – Vinod Srivastav Jun 16 '18 at 14:54

Convert XML file to csv file format in c#

4 Answers4

Steps